Matrix Grand Total Row

[Anonymous]

Hi in this screen shot below, I am facing an issue with the grand total percentage. The percentage collum is getting summed. Rather I want it as (2139/2579)*100 as the percent. Can anyone help with this??

[TomMartens · Accepted solution]

Hey @Anonymous ,

you have to create a measure like so:

measure = 
divide(
calculate( sum( '<yourtable>'[denominator] ) )
, calculate( sum( '<yourtable>'[denominator] ) )
)

If your numeric values are already measures, you can use this instead:

measure = 
divide(
[measure1]
,[measure2]
)

Hopefully, this provides what you are looking for.

Regards,

Tom