Market Share at any level

[Anonymous]

Hello,

I would like to calculate a market share that fits the context of the graph.

Here is the graph I want to use.

So far, I manage to make a global market share.

I would like to have a total of 100% in each category (column).

My users are allowed to change categories if they want : delete categories, or add other categories from my Product Table.

My measure : SUM ( ' Sales '[amount])

My table for categories : Product

Thanks for your help 🙂

[Anonymous]

If you have a hierarchy, and you clearly have, you have to create a measure using ISINSCOPE and such a measure will be tightly coupled with your hierarchy. DAX is not the greatest with such a design, so the measure will only have to be used when this hierarchy is (correctly!) placed in a visual.

Here is a full and correct treatment of how such things should be handled and built.

Hierarchies – DAX Patterns