Hello Gerda,
I have created the below calculated measure which almost works:
NonZero(
sum(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
Not IsEmpty([Measures].[Issues resolved])
AND
DateDiffDays(
TimestampToDate((
[Measures].[Transition to status last timestamp],
[Transition Status].[Awaiting Odds]
)),
[Issue].CurrentHierarchyMember.get(‘Start Date’)
) <=5 ),
[Measures].[Issues resolved]
)
)
The issue I have is that when I use the Time dimension to get the monthly summary, the calculated measure above is not picking up issues that have an awaiting odds time stamp in a different month the the month that the issues were resolved in.
I am trying to get to the point that I can summarise for say the month of November, how many of the 44 issues with a resolved date in november were within the 5 day SLA. When I complete it manually I know that there are 36 but 3 issues are being missed as the awaiting odds timestamp falls in October.
Many Thanks
Carly