EazyBi - Average number of Days to first Achieve a Transition Status

[Brad Johnson]

I am trying to create a calculated member that will show the average number of workdays certain groups of issues take to first achieve a given status. My MDX is below. However, this doesn't return any values. The cells of the table are blank.

CASE WHEN [Measures].[Transitions to status] > 0 THEN 
 DateDiffWorkdays([Measures].[Issue created date], [Measures].[Transition to status first date]) /
 [Measures].[Transitions to status]
END

Additionally, I would also like to measure the average workdays these issues take between achieving this status and being closed.

Any help is greatly appreciated 

[Brad Johnson · Accepted solution]

The helpful folks at eazyBI were able to point me in the right direction. Below is the correct solution:

Avg(
 Filter(
 Descendants([Issue].CurrentMember, [Issue].[Issue]),
 [Measures].[Transitions to status] > 0 
 ),
 DateDiffWorkdays(
 [Issue].CurrentHierarchyMember.get('Created at'), 
 [Measures].[Transition to status first date])
)