Forum Discussion
LatverianKid
3 years agoFrequent Visitor
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
Thank you in advance
1 Reply
- ribisht17
Super User
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