I have created the below calculated measure which almost works:
Not IsEmpty([Measures].[Issues resolved])
[Measures].[Transition to status last timestamp],
[Transition Status].[Awaiting Odds]
) <=5 ),
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.