Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Experts,
I need your help in calculationg Market share for below table.
Country | Subproduct | Product | Values |
c01 | p1 | 1500 | |
c02 | sp2 | p2 | 2000 |
c03 | p3 | 1800 | |
c04 | sp4 | p4 | 3000 |
c05 | p5 | 1500 | |
c06 | sp2 | p6 | 2000 |
c07 | p7 | 1800 | |
c08 | sp4 | p8 | 3000 |
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?
Thanks
Krishna
Hey,
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.
Regards,
Tom
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.
Thanks
Krishna
Hi Experts,
Can you please help?
Thanks
Krishna
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |