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.
Hello everyone
I'm something new using power BI and I have a problem using RANKX and a Slicer. I attach two images of what happens when you select a year with the slicer and when it is not selected.
When using the slicer and works correctly and shows me the ranking starting from 1
The measure I am using is as follows:
Hope this helps:
Hey @Syndicate_Admin ,
this will not work because you have a single table solution, because of this ALLSELECTED will consider all countries no matter the filter applied by the slicer. This will result to strange "values".
Regards,
Tom
User | Count |
---|---|
85 | |
72 | |
71 | |
67 | |
56 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |