Forum Discussion

LatverianKid's avatar
LatverianKid
Frequent Visitor
3 years ago

RANKX with filter

Hi everyone, 

I'm having troubles with a RANKX. I'm trying to rank the countries based on the HappinnessRank variable. However, when I apply the filter, the rankx is not working properly and instead of showing "1" for the first item, its showing a higher value.

The DAX formula i'm using is the following 

Rank_Country = RANKX(ALLSELECTED(WorldHappiness[Country]),[Ranking],,ASC,Skip)

Without filterwith the 2019 filter applied
 
Hope that you can help me,

Thank you in advance