Sum of Calculated Measure

Questions & Answers
,
1

Hi,

I’m trying to build a report that compares two fields.
I have created 2 calculated measures:
“On time”
CASE WHEN
[Measures].[Issue fix versions] MATCHES [Measures].[Issue Planned Fix Version]
THEN 1
END

“Delayed”
CASE WHEN
[Measures].[Issue fix versions] NOT MATCHES [Measures].[Issue Planned Fix Version]
THEN 1
END

I want to display, All issues, how many are delayed and how many are on time. However, I can’t get the sum of On time vs. Delayed to display correctly on the report.

the table displayed the count for total issues but not the count for the measures.

Thoughts ?

image
image1207×668 68.6 KB

2

Resolved by using this formula:
NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
[Measures].[Issues created]> 0 AND
[Measures].[On Time]>0
)
)
)

Note that [Measures].[On Time] compares between the planned version and the fix version.

Hope this helps someone :slight_smile:

1 Like