I’m attempting to count the tasks that have reached a status of ‘Closed’ and ‘Done’ within a fiscal year that runs from July to June and I’m missing something to make the measure work correctly.
NonZero(Count(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
DateCompare([Measures].[Transition to status first date],
DateParse(“Jul 01 2021”))>0
AND
[Status].[Closed],[Status].[Done]
)
))
There is a built-in possibility to introduce Fiscal hierarchy in the Time dimension which you can use.
You can find more about it in the documentation: Time dimension
Then the only measure you need to select is the Transition to status issues count measure. It will return a distinct count of issues that transitioned to historical statuses in the displayed period.
Finally, you can simply put the Transition Status dimension in Pages and filter by “Closed” and “Done” to calculate a report only for certain historical statuses.
Nauris / eazyBI support
