Calculate median for workdays in transition status by status

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.

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


Hi @Carlos_Javier_Prieto

try using the feature “Drill into measure” for your calculated measure and drill it into “Transition” dimension.
But before you explore this feature, remove the “Transition” dimension (temporarily) from the report columns.

Martins / eazyBI