Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
User | Count |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |