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.

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

easybiinquery

Hi @Carlos_Javier_Prieto

try using the feature “Drill into measure” for your calculated measure and drill it into “Transition” dimension.
https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Drillintomeasurebyanotherdimensionlevel
But before you explore this feature, remove the “Transition” dimension (temporarily) from the report columns.

Martins / eazyBI