Hi team
I am trying to calculate mediam for workdays in transition status . I used the following formula . This formula work fine but I dont not how can i filter for an specifed status for example issues that move to status 1 to status 2.
Median(Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
[Measures].[Average workdays in transition status] > 0
),
[Measures].[Workdays in transition status]
)
Actually I need to delete the first column in the imagen and only see the median for status seleted ( Column 2 ) but if i delete the first column i dont see anything because the status that i would like to filter isn´t in the formula of median