RANKX with slicer

[Syndicate_Admin]

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 deberiaSin el slicer, funciona correctamente y me muestra el ranking iniciando a partir de 1
The measure I am using is as follows:

Filtered ranking = RANKX(ALLSELECTED('Data-WorldHappiness'[WorldHappiness[Country]]]),[Ranking],,ASC,Skip)


Similarly, I share the pbix file and the dataset that I am using

https://drive.google.com/drive/folders/1ifjnoo7WjkggXu_oBV0beB8kP0EcXi8b

Thanks in advance

[Padycosmos]

Hope this helps:

Ranking filtrado = RANKX(ALLSELECTED('Data-WorldHappiness'[WorldHappiness[Country]]],'Data-WorldHappiness'[WorldHappiness[Año]]]),[Ranking],,ASC,Dense)

[Padycosmos]

Hope this video helps:

https://www.youtube.com/watch?v=inJ3Yt7ay30

[TomMartens]

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