I am trying to build the below report:
Unfortunately without a success.
Could you please guide me to make it working correctly?
I tried with many custom measures but the recent one is as follows (for the specific Transation Status):
Sum( Filter( Descendants([Time].CurrentHierarchyMember,[Time].CurrentHierarchy.Levels("Day")), DateBetween( [Time].CurrentHierarchyMember.StartDate, ([Transition Status].[In Design],[Issue Type].[Epic],[Measures].[Transition to status first date]), ([Transition Status].[In Design],[Issue Type].[Epic],[Measures].[Transition from status last date]) ) ), ([Measures].[Hours spent],[Logged by].CurrentMember) )
Thanks in advance for your support.