Small multiples: % of Total of every single multiple

[rainerpowerbi]

Hi,
I have following data:

Using small multiples I can create this visual with the following share per complete total:

My question: is it possible to create this visual with changed TOTAL-base. New TOTAL-base shall be the TOTAL of every single multiple instead of the complete TOTAL.

Kind regards

Rainer

[amitchandak · Accepted solution]

@rainerpowerbi , Create measures like

divide([Measure], calculate([Measure, filter(allselected(Table), Table[entity] = max(Table[entity] ) ))

[RobG123]

Hi I don't really follow. Can you rainerpowerbi supply the actual code used? I have the same problem

[Aysha99]

Have you been able to solve it?

[rainerpowerbi]

Hi amitchandak,

THANKS !!!!

Kind regards

Rainer