The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 🙂
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.
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
8 | |
8 |