Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Matrix Grand Total Row

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??

 

 

Need Help
Tips and Tricks
  • TomMartens's avatar
    TomMartens
    3 years ago

    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

     

1 Reply

  • TomMartens's avatar
    TomMartens
    Super User
    3 years ago

    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