Rank Measure

[Krcmajster]

I am having trouble figuring this one out. 

I had a calculated column that did a great job:

KPI rank = RANK.EQ(Table[KPI],Table[KPI],DESC)

However, since we moved to database I can't use calc columns anymore, so I need to do the same with a measure but I am always getting 1 for every location when using rankx. This measure (or more) needs to work on a table and on a Card when drillthrough to individual Location so that rank is the same

let's say table is simple:

LocationID                KPI

[Tahreem24]

@Krcmajster ,

Please try below DAX MEasure:

MEASURE RANK = RANKX(TableName, CALCULATE(SUM(Table[NumericCOlumn]),ALLEXCEPT(TableName,TableName[ColumnName on which you want ranking])),,DESC,DENSE)

[amitchandak · Accepted solution]

@Krcmajster ,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
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...