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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Helper I
Helper I

Urgent: Market Share Calculation

Hi Experts,


I need your help in calculationg Market share for below table.

c01 p11500
c03 p31800
c05 p51500
c07 p71800


From above table i want to calculate top 5 products based on market shares.

Market share should be calculated on subproduct, if subproduct is not there then it should be calculated on Country.


can you please help in calculating the market share?




Super User
Super User



I'm wondering if you want to create a measure or a calculated column.


How do yout want to visualize this newly calculated information, you have to be aware that it is currently not possible to mix values from different columns on an axis.


For this reason I thing it will become necessary to create an additional column, that you can use as an axis in visuals or as a row/column header in a table or matrix visual.


Please provide your expected result for a single product (if this calculation is possible), subproduct sp2 and c01.


And my final question, is there a coutry code that can be confused with a subproduct code, because both have the same value.




Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hi Tom,


Thanks for responding my question. I want to create measure to calculate the market share.  The market share should be calculated at subproduct level, wherenever subproduct doesnot have the value then maket share should be calculated at country level.


I can acheive this if i have to calculate at one level either subproduct or country but how to calculate on both levels based on available values.


Please do not go by data(country id & subproduct code), this is just mockup to explin the problem, i have some other columns month,year etc to display the values the values. 


My expected result is to display top 5 products based on market share.




Hi Experts,


Can you please help?




Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.