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 everyone,
I would like to show the ranking of a variable in a table.
Let me explain, from the below very simple dataset, I want to create a straight table.
The table would be linked to 3 slicers
- Market
- Day
- Session
Let's say we filter on
Market => ES
Day => Mon
Session => ODR
The table would only be showing one line.
But I would like another column in the table that would give me the ranking of the Market and Session combinations (including all days).
So it's this instance, the ranking would be 4 (1% being the lowest number out of the 4 days).
Thank you!
Hi, @Arthur_NS
I didn't grasp the requirement fully, whatever I understood I tried to reproduce your problem and the result is,
Used this dax
Proud to be a Super User!
Hello,
I'm trying your solution but it gives me this error message
Are you trying to create a measure? As you can see from the ss I created a calculated column. So, you need to create a calculated column.
Proud to be a Super User!
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |