Counting number of objects based ona value

Rami Khader

Hi,

Is it possible to create a calculated measure that count number of the created objects if a value of another measure >0

 

Thanks

Rami

Daina Tupule eazyBI

Hello Rami,

 

You would like to use object-level calculations when you would need to count objects based on two different measures. Here is an example formula:

Sum(
Filter(
Descendants([Object].CurrentMember, [Object].[Object]),
DateInPeriod(
[Measures].[Object created date],
[Time].CurrentHierarchyMember
)
),
-- count objects created if value in another measure is > 0
CASE WHEN [Measures].[another measure] > 0 -- set your measure name here
THEN [Measures].[Objects created]
END
)

Set the formatting for this measure to integer explicitly. eazyBI might not detect the data type of the results by default. 

The formula is quite general. You might want to update it by adding additional filters or exceptions according to you your particular use case.

 

Daina / support@eazybi.com