I’m trying to create a report where I need to see all tickets that were historically or are in “In Progress” status and a list of their Assign in this status.
Currently, I only receive a historical list Assignees of tickets that are currently in “In Progress” status. But I also need to see the tickets that were historically in this status and their Assignee.
How do I extend MDX with historical issues (only tickets currently in “In Progress” status are displayed)?
I have this Calculated Measure:
Generate( --go through all Assignee users Filter( [Assignee].[User].Members, --check wheather user was assigned to issue at some point ([Measures].[Transitions to assignee], [Time].CurrentHierarchy.DefaultMember) > 0 ), --get assignee names separated by comma [Assignee].CurrentMember.Name, "," )
Thank you for your help