Percentage of (sub)total


It’s me again…

I want to do an analysis on which status are really used in my Jira projects. I am using measure “Transition to status issues count” which works perfect.

What I now want is to add a percentage per project (like having a subtotal of issues), but when I add the “% of total” it is calculated by all rows selected. Is it possible to add a filter on the projected of the row?

See the red marks in this screenshot:

Thanks to this post I was able to find a solution to my topic.

This is the measure I am using now:

[Measures].[Transitions to status issues count]
([Measures].[Transitions to status],
[Issue Type].CurrentHierarchyMember)