By default, the measure
Days in transition status calculates the time (in days) only for completed workflow transitions and therefore it can’t be used to calculate the time in the current status.
However, the following MDX formula (use it to define a new calculated member in
Measures) will include into the calculation also days in the current status:
NonZero( Cache( -- days in transition status when issue was in this status previously [Measures].[Days in transition status] + -- days since last transition to this status IIF([Measures].[Issues history] > 0, DateDiffDays( ( [Measures].[Transition to status last date], [Time].CurrentHierarchy.DefaultMember ), Now() ), 0 ) ) )