Counting unique transitions to status

Questions & Answers
1

Hi,

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.

Count(
Filter(
–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:

2

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:

Aggregate({
  [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