Average days in transition status + average days in current status

Questions & Answers
2

Hi,

The infinity is because you are trying to divide by empty Issues created count.
You would need to add additional criteria for the second part of your calculation (Issues created count > 0 )
But I believe the way you are trying to calculate the total average results would not be correct anyway.

Actually, in this case, I would recommend a different approach:

  1. create a calculated measure (you can take the code example from our DEMO account) that would return “Days in transition status till now” for each issue.

  2. create another calculated measure that calculates the average results for these issues using the measure from step1

    NonZero(Avg(
  Filter(
    Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    [Measures].[Days in transition status till now] >= 0),
  [Measures].[Days in transition status till now]
 ))

Martins / eazyBI support

1 Like