Forum Discussion
Madhusmita
3 years agoFrequent Visitor
Rank calculation based on dynamic dimension parameter
HI Team, Can anyone please help me with the below Rank calculation. Rank = RANKX(ALL(RESULTS[Country]),CALCULATE(SUM(RESULTS[CADRE POINTS]))) - Working Rank = RANKX(ALL(p.Dimension[p.Dimen...
Sahir_Maharaj
3 years agoSuper User
For the Name dimension, you can create another measure:
Rank by Name = RANKX(ALL(RESULTS[Name]), CALCULATE(SUM(RESULTS[CADRE POINTS])))