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 · Accepted solution]

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

[Rami Khader]

Thanks Dania, that was helpful

[Fabian Lim]

Hi @Rami Khader

Yes it's possible. I'm assuming you are using insight.

Put the objects in the rows and then create a defined measure. Not clear what you are looking for, so here are some instructions: https://docs.eazybi.com/eazybi/data-import/data-from-jira-apps/insight-asset-management#InsightAssetManagement-ImportInsightcustomfieldattributesforJiraissues