Average work hours between creation and first assignment

Hello,
I wrote down the “single issue” measure but I need some help to generalize it.
I have a “work hours between creation and first assignment”, that is:

DateDiffWorkhours(
[Measures].[First Assignee Date], [Measures].[first date to in progress])

where the “first date to in progress” is:

([Measures].[Transition to status first date],[Transition Status].[In Progress])

I need it to scale to get the average for an issue type, so that I have the issue type on rows and the average on measures.
How can I do it?
regards.

Hi Mauro_Bennici,
Welcome to the eazyBI community!

Try this formula, that filters all issues that were created in report Time period and calculates average of how many work hours it has taken them from “First Assignee Date” till “first date to in progress”:

AVG(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
  [Measures].[Issues created]>0), -- filters all issues created in report Time period
DateDiffWorkhours(
 [Measures].[First Assignee Date]
,[Measures].[first date to in progress])
)

To get the first ever date in Progress (not the first date in selected Time period), I would suggest to add [Time].CurrentHierarchy.DefaultMember to measure “first date to in progress” formula:

([Measures].[Transition to status first date]
,[Transition Status].[In Progress]
,[Time].CurrentHierarchy.DefaultMember)

Let me know if that works for you or if you have some questions.

Kindly,
Ilze

thanks @ilze.krauze !
I came around something like it but used DescendantsSet instead of Descendants, if I get it right I’m using more memory :\