Ranking issue with RANKX

[OmarSaleh]

Hello

Can anyone please help resolving the following issue with RANKX. 

I'm trying to create a new measure to rank the names in below table based on their scores using RANKX 

 Rank = RANKX(All(Digital_Interactions),[Score])

Score is another measure that's calculated by multibliing and summing multible measures

Thanks!

[amitchandak · Accepted solution]

@OmarSaleh , what is the issue you are facing is not clear

You can try, assume you have name column 

Rank = RANKX(All(Digital_Interactions[Name]),[Score])

Rank = RANKX(AllSELECTED(Digital_Interactions[Name]),[Score])

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns

[OmarSaleh]

Sorry @amitchandak just realised that I didn't mention the Name column after the table. It's working now thank you! 

[OmarSaleh]

Thanks @amitchandak for your reply. The issue is that I'm getting the same rank for all names even though I used ALL function as you advised. I don't have the score as a calculated column, it's a measure. 

[amitchandak]

@OmarSaleh , if you have created a measure rank on the name column and use another column in the visual. All Ranks will be done inside the second column 

refer

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