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 selecting any year, the first position indicates a higher number than it should Without the slicer, itworks correctly and shows me the ranking starting from 1Al usar el slicer y seleccionar cualquier año, la primer posicion indica un numero mayor al que deberia
Sin el slicer, funciona correctamente y me muestra el ranking iniciando a partir de 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 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |