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 All,
I am trying to get top 10 brands with their share % and other should be give share % for rest of the brands.
I checked a few methods which helped me getting my top 10 share but other is giving 100 % which is not the right value.
DAX
1. I created a separate brand table with Other as new row as below.
Can someone help me in this?
Solved! Go to Solution.
Hi All,
Its resolved. Solved by modifying Brand Share% measure. Used All in place of Allselected fulfilled my requirement.
Thank you
Hi All,
Its resolved. Solved by modifying Brand Share% measure. Used All in place of Allselected fulfilled my requirement.
Thank you
Hi, @deepalig
Glad to hear you solved the problem yourself!
Congratulations
Best Regards
Yongkang Hua
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
176 | |
83 | |
69 | |
65 | |
54 |