Percentage of row total - in line grapth

[NewbieJono]

Hello all - I have a trend with M and F lines showing numbers on a month by month basis.

i would like to show the precentage split instead of the numbers. I can do this using a matrix table and slecting "show as percentage of row total". however this is not available on my line chart. only show as percentage of coloumn total.

is there any dax i can use to solve this for my line chart.

here are my current outputs

please ignore the date ordering of my matrix table!

Thanks all

[Anonymous · Accepted solution]

% count = CALCULATE(COUNT(Employee[EmplID]))/CALCULATE(COUNT(Employee[EmplID]),ALL(Gender))

Hope this Dax will help.