Forum Discussion

natasha519's avatar
natasha519
Helper II
4 years ago

How to calculate proportion

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 t...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

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.