How to show 100% total for each month for all legends combined rather than 100% total of all data.

[tusharkumar]

Hi, I have attached the screenshots for refernece. Please check. Your kind help is very much appreciated. 

I am supposed to dislay 100% total for each month, (please refer to the image attached) for say - all three dots of July should up to 100%, but currently all the dots from May to September add up to 100%. And I'm bound to use this simple line chart only. 

I want to display 0-100% range on y-axis but not by manually changing the range value from format visual option. That won't work  in this case anyways. 

Please Note : I fear, I can't attach this .pbix file to this question as it has some confidentional data of patients. 

Thank You! Kindly Help
As you can see the %ge is distributed over all the months.

I've these columns as of now.

[Ashish_Mathur · Accepted solution]

Hi,

Try these measures

Count = countrows(Discharge dur to death)

Count across all exceptions = calculate([Count],all(Discharge dur to death[Exception]))

% = divide([Count],[Count across all exceptions])

Hope this helps.

[tusharkumar]

Thank you so much, Ashish. It works 🙂 Can't thank you enough. 

[Ashish_Mathur]

You are welcome.

[HoangHugo]

hi, can you share Dax of measure %GT Count of Status

[amitchandak]

@tusharkumar ,when you use the line on the clustered line visual, it will not split by legend so you can not show % of Subtotal using that

% of Subtotal = Divide(Count(Table[Status]), Calculate(Count(Table[Status]), removefilters(Table[Exception])))