Count of "Fix Failed" by User that Fixed the Issue


I want to know, how many issues were set to Resolution “Fix Failed” from the issues a user has previously transitioned from Status Open to Status To be Regressed.

EX: UserA transitions issue-123 from Open to To be Regressed. Later UserB transition issue-123 to resolution Fix Failed. I want that issue to be counted toward UserA.

So far, I have my Transition Author dimension in Rows,
I use [Measure].[transition to status], [Transition].[Open => To be Regressed] in columns.
I don’t know how to count issues amongst those that were Fix Failed.

Can someone help please?



This was fixed through email with EazyBI Support.
For anyone who might have a similar issue, here is the fix they provided.

Please note this formula does not use any filters by properties. Therefore it might work slow or fail to load in larger accounts:

Descendants([Issue].CurrentMember, [Issue].[Issue]),
    [Measures].[Transitions to],
    [Transition Field].[Resolution],
    [Resolution].[Fix Failed], 
  )) > 0
NonZero(([Measures].[Transitions to status issues count],
[Transition].[Open => To be Regressed]))