Forum Discussion
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...
To resolve this, you can create a separate measure for each dimension that you want to use for ranking and then switch between these measures based on the selected dimension in the parameter. For example, for the Country dimension, you can create the following measure:
Rank by Country = RANKX(ALL(RESULTS[Country]), CALCULATE(SUM(RESULTS[CADRE POINTS])))
Hi Sahir,
Thank you for the response, so, instead of All what can i use?