How to remove Epics from a calculated measure

Questions & Answers
1

Good morning, I am using this calculated measure, “Average Resolution Days from InProgress to Done” and I would like to know if is possible to remove the Epic’s from this equation.

Avg(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
[Measures].[Issues resolved]>0
),
DateDiffDays(
([Measures].[Transition to status first date],
[Transition Status].[In Progress],
[Time].CurrentHierarchy.DefaultMember),
([Measures].[Transition to status last date],
[Transition Status].[Decline and Done statuses],
[Time].CurrentHierarchy.DefaultMember)
)
)

Thank you

2

Hi, @Sara_Chaves

To exclude the Epics from Average Resolution days you need to add criteria to your calculation:

AND [Measures].[Issue type] <> "Epic"

So, full calculation will look like this:

Avg(
Filter(
 Descendants([Issue].CurrentMember,[Issue].[Issue]),
 [Measures].[Issues resolved]>0
--& Issue type is not Epic
AND [Measures].[Issue type] <> "Epic"
),
--Number of days from "In Progress" to "Decline" or "Done"
DateDiffDays(
(
[Measures].[Transition to status first date],
[Transition Status].[In Progress],
[Time].CurrentHierarchy.DefaultMember
),
([Measures].[Transition to status last date],
[Transition Status].[Decline and Done statuses],
[Time].CurrentHierarchy.DefaultMember)
)
)

Best regards,
Ilze Mezīte support@eazybi.com