How do I filter the default calculated member "Open Issues" by a specific status?
I want to show all Issues that were either in status1 or status2 at each week in the past.
On example, if I had 3 open Issues in status1 and 2 open issues in status 2 at week 45 in 2019 I want to see 5 as a result for that week.
The following calculated member only gives me the right result for the last, respectively actual week:
([Measures].[Open Issues], [Status].[status1])
+ ([Measures].[Open Issues], [Status].[status2])
Is there a way to get the number of Issues, that were in one of the statuses for each week?
