That solves half my problem, thanks Jyothish!
My other problem now is that I want to limit this to the top 10, but when I limit to a fixed number of 10 it only shows the top 10 for the first measure (which is Active). Is there any way I can make the 'calculated by measure' to show the top 10 of total?
Edit: Sorry I replied after you posted. I'll try that out.
Understand this is a bit of an old post but didn't want to create a new one for a minor issue I am having with the above. I have tried using the following formula to order by stacked bar chart, however the order doesn't seem to have worked?
Could someone please help with this?