Filter TOPN Values of a Measure

[Anonymous]

Good Morning,

I'm new to DAX

So I have this Dataset(Values Removed):

From it I did a Measure:

The Idea is to show the 15 Worses of this measure inside a Table:

Since its a Measure I was not able to filter by TOPN using the Visual Filter.

So What i thought was to do another Measure, a RANKX that would RANK the worst values of DesvioOrcadoAtéOMesAtual Measure and then use the Visual Filter to Filter numbers smaller than 15:

[EDIT]:

Pos = IF(NOT(ISBLANK(Desvio[DesvioOrçadoAtéMesAtuall])),RANKX(ALLSELECTED(Desvio),Desvio[DesvioOrçadoAtéMesAtuall],,1))

Did this change but did not work.

[/EDIT]

The Problem was that as we can see the "Pos" Column repeat a lot of time the same RANK Number.... And the values are different so it should not.

I want to be able to filter by the left filter of departaments, so when has no filter i would show the worst values at all and when its filtered by departament it would show the 15 worses values of that departament....

[Anonymous]

Believe the problem is linked to the CALCULATE measure , perhaps the FILTER is messing with the values... but aint sure.... 

[harshnathani]

HI @Anonymous ,

See if these help

https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/

Regards,

HArsh Nathani

[Anonymous]

Thanks Harsh Natani,

The thing is the values in the column i want to rank are not the same... In fact they are quite different.... So the tutorial did not help... But thanks a lot!

Regards,

[EDIT]

Just to Show that the RANK has no sense at all(sorry for the img quality, forgot to ss before

[/EDIT]