How to calculate proportion

[natasha519]

Hello,

I am using a matrix to create a heat map (used conditional formatting for background) so each cell has a different number of documents. How can I show the proportion as well? For example in this one cell, 196/13621 so 1.43% to show up in the tooltip? But this percentage will obviously change when you hover over other cells since numerator will be different. Screenshot below for reference

[v-jingzhang]

Hi @natasha519 

Assume you use Count aggregation to get 196 and 13621, you can create a measure like below to calculate the proportion. Then use the report tooltip page feature to display this measure along with other tooltip fields. 

proportion =
DIVIDE (
    COUNT ( 'tablename'[Documents] ),
    CALCULATE ( COUNT ( 'tablename'[Documents] ), ALL ( 'tablename' ) )
)

For visuals that have Tooltips well, you can put a measure into this well easily. However Matrix doesn't have this well, so you need to create a custom tooltip page for it. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[mussaenda]

Hi @natasha519 ,

If I understood you correctly, you want the percentage to show on the data?

You can put again the value and the right click, show value as then choose percent of grand total

Hope this helps

[natasha519]

I tried this, but am not sure what it is showing the percent of grand total of. When I divide the number that's currently displaying by total I am not getting the correct percentage