Unique Count of Issue Priority Transition

Hi - trying to get a count each month of the number of “escalation” issues we have, which we define as issues that have been set to (not necessarily created with) a priority of Critical or Blocker. This function is returning a count > 1 per issue. Can you please advise how to get a unique count (1) per issue in MDX?

Aggregate({
[Priority].[Critical - Do ASAP],[Priority].[Blocker - Do NOW]},
[Measures].[Transitions to]
)

Thanks,
Ben

Hi Ben,

There is another useful measure for counting the issues having transitions in a field:
[Measures].[Transitions to issues count] for counting the distint issues having the transitions.

This formula should also use the specific transitions field to count only on the chantes in the Priority:

Aggregate(
  {[Priority].[Critical - Do ASAP],[Priority].[Blocker - Do NOW]},
  ([Measures].[Transitions to issues count],
   [Transition Field].[Priority])
)

Kindly,
Janis, eazyBI support

That looks much better, thank you.