RANKX with filter

[LatverianKid]

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

[ribisht17]

@LatverianKid 

You are filtering with Date , hence Date should be within ALLSELECTED but you have Country

> https://hevodata.com/learn/dax-allselected/#ex1

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series