Need Average of Child Issues Associated with Epic (Average at Epic Level) of In Progress to Resolution time

Hello,

I am working on one report in which I want to pull Average of Child Issues Associated with Epic (Average at Epic Level) of In Progress to Resolution time, Assigned to Resolution time. I have written the below measure but it is not working -

(NonZero(
Avg(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Measures].[Assigned Date]>0
)
,
[Measures].[Time Difference (Assigned to resolution)]
)))2460

Measure Time Difference (Assigned to resolution) -

DateDiffDays([Measures].[Assigned Date],[Measures].[Resolution Time stamp])

Can anyone please suggest me on this.

Thanks

Hi @ankit9218

Can you share more details on what exactly is not working? Is it wrong or empty or does it give you an error?
Also, how do you define the measure “Assigned Date”?

Martins / eazyBI

Hi Martin

Basically I want Assignee wise Epic wise average of time difference between assigned time stamp to resolution time stamp.

Thanks!