Small Multiple - % Total

[Anonymous]

Hi everyone,

I've recently been creating a small multiple bar chart, however within each small multiple, I would like to be able to add a tooltip to show the bar value as a % of the small multiple total, rather than the grand total across all 4 of the below charts. I've added a dummy mock up below to demonstrate what my set up is similar to but for example, I'm looking to show what the value of the CAT A bar as a % of the total within the A small multiple, so it's equal to 10% in this instance. 

Any thoughts would be much appreciated on how to calculate this measure please! Thanks

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

Try to create a measure like this:

Measure = 
DIVIDE(MAX('Table'[Value]),CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Attribute])))

Result:

Please refer to the attachment below for details. Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.