Unresolved issues NOT created within the month


I am trying to construct a bar chart report where it states the issues created and resolved within the same month. The calculated measure that I used for filtering out the issues created & closed in the same month is:

Descendants([Issue].Currentmember, [Issue].[Issue]),
[Measures].[Issue created date],
[Measures].[Issue resolution date],

The report takes Time (in months) as the row parameter and in the same report, I also would like to display the issues created earlier than the current month. For example; at the month of September there are 50 issues created and 25 out of this 50 is resolved. However, there are 100 more tickets created before September which I also would like to show separately.

How can I count the issues created earlier than the month that I am looking into and were not resolved during the month as well?


Sorted out after filtering out the Unresolved issues from Transition Status dimension.


1 Like