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.
Dear all,
I want to create a table that look like this.
How can I make share by brand?
Thank you
Solved! Go to Solution.
Try
Market Share = divide(sum(Table[Sales]), calculate(sum(Table[Sales]),allselected(table)))
OR
Market Share = divide(sum(Table[Sales]), calculate(sum(Table[Sales]),all(table)))
Try
Market Share = divide(sum(Table[Sales]), calculate(sum(Table[Sales]),allselected(table)))
OR
Market Share = divide(sum(Table[Sales]), calculate(sum(Table[Sales]),all(table)))
Dear amitchandak,
It's work. Thank you very much
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
189 | |
96 | |
67 | |
63 | |
53 |