Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
66 | |
64 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |