Need Help In Ranking ?

[Suman8877]

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.

[rohit1991 · Accepted solution]

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])