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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |