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...
Hello Madhusmita,
The issue is happening because the RANKX function expects a table expression as the first argument. When you use ALL(RESULTS[Country]), you are passing a table expression that includes only the Country column. However, when you use ALL(p.Dimension[p.Dimension]), you are passing a table expression that includes multiple columns (Country, Name, Region, and Category).