Counting unique transitions to status


I am trying to get a unique count of transitions to status for multiple transitions (no duplicates). Using:
[Transition Status].[Done] + [Transition Status].[Production Ready] is producing results with a count of 2 for items that were in both of these statuses. I only want to count 1 of them in the results.

I tried this MDX, modified based on a search of previous questions, but it is not working. I am using this as a custom measure in Transition Status.

–go through individual issues
Descendants([Transition Status].CurrentHierarchyMember,[Transition Status].[Transition Status]),
–for each issue validate both criteria
[Transition Status].[Done] > 0 OR
[Transition Status].[Closed] > 0

Thank you :wink:

Hi @Seth44

Do I understand correctly that you would like to count the number of issues that have been in the “Done” or “Production Ready” status or both, right?

You can define a new calculated measure in the Measures dimension with the following formula:

  [Transition Status].[Production Ready],
  [Transition Status].[Done]
[Measures].[Transitions to status issues count]

Let me know if this fits your use case!

Best regards,
Nauris / eazyBI support