Change Rank Dynamically to the Filters selected by the user

[Crobby_09]

I have data consisting of route details of the customers and also their store scores. Pfa raw data with overall ranking for all the customers 

This is the overall ranking for all the customers without selecting any filters. So when I select some filter like (Dist name, route code, store score) I want it to show the Rank according to the selected filter. Eg :

The store score is based on some parameter which I calculated in a model using python. 

Currently it is string column in powerbi. I tried some dax but it was not succesful. kindly suggest me a solution. thanks

[amitchandak]

@Crobby_09 , assuming store score is a measure or create a measure using sum/average

s1= Sum(Table[Store Sore])

rankx(allselected(Table[(Dist name], Table[route code], Table[store], Table[State]), [s1],,desc,dense)

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

Measure Rank: https://www.youtube.com/watch?v=DZb_6j6WuZ0&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=40
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=25627s

Power BI Rank Across dimension tables: https://youtu.be/X59qp5gfQoA