Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi all,
I'm building dashboard and I'd like to display the rank of the brand based on its market share.
The data looks like:
Category | Brand | Value |
C1 | B1 | 10 |
C1 | B2 | 5 |
C1 | B3 | 1 |
C2 | B1 | 50 |
C2 | B2 | 10 |
Market share is calculated based on the Value column, and I'd have separate table for each category where filter on the each visual (table) would be different category.
I have a measure to calculate brand share but when I throw it in the RANKX function it returns me all the same values:
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |