Forum Discussion
Need Help In Ranking ?
I have one table that have 3 columns
1. country
2. Score
3. Rank
then i create a measure to calculate average(Score for few group of country.. e.g Europe, APAC,
my question is how to rank the measure value(average) inside the above list OR can we create the measure to calculate the rank
e.g
AvgValue for Europe = 49.90
Country Score Rank
Austria 50.80 21
Australia 50.20 22
Estonia 49.50 23
>>> wanted result.. rank for "avgValue for Europe" = 23
thnaks in advance for any help.
Hi Suman8877
To get solution please follow the following procedure below:Make a copy in Power Query Editor, select the [Country] and [Continent] columns and execute Unpivot Columns.
Remove unwanted columns.
Create two new measures.
AVG OF SCORE = AVERAGE('Table2'[Score])RANKING = RANKX(ALLSELECTED('Table2'[Area]),[AVG OF SCORE])
1 Reply
Hi Suman8877
To get solution please follow the following procedure below:Make a copy in Power Query Editor, select the [Country] and [Continent] columns and execute Unpivot Columns.
Remove unwanted columns.
Create two new measures.
AVG OF SCORE = AVERAGE('Table2'[Score])RANKING = RANKX(ALLSELECTED('Table2'[Area]),[AVG OF SCORE])