I have a problem calculating median days in transition status. I use this custom measure:
([Measures].[Transitions from status],[Time].CurrentHierarchy.DefaultMember) > 0
[Measures].[Days in transition status])
Then in columns I also add “Transition status” so I can selecte a specific Transition status.
Some issues are calculated with a value which is a multiple of the actual “Days in transition status”. the factor is the same as the value of “Transitions from status” measure.
It looks like this behaviour is cause by the use of such a “calculated member”
What I want to accomplish with the calculated member is to get all Issues in Project P1 which have component API or Web,
But now in my measure “Days in transition status” is summed up not per issue, but by issue/component.
Can I build the “calculated member” in another way so the measures are not summed up?