Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Market Share at any level

Hello,

 

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

Here is the graph I want to use.

Capture.JPG

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 🙂

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.