Ranking columns

[GeoSans]

Hello!

I have the following table:

Student	Exercise 1	Exercise 2	Exercise 3
Merry	5	4	2
John	8	6	5
Pedro	2	7	5

I would like to visualize a ranking with the exercise in order to see which one were easier for the students and which were the hardest for them.

How can I do this?

Thank you!

[AmiraBedh]

For each exercise, you would create a measure like this:

Average Exercise 1 = AVERAGE(YourTableName[Exercise 1])
Average Exercise 2 = AVERAGE(YourTableName[Exercise 2])
Average Exercise 3 = AVERAGE(YourTableName[Exercise 3])

[olgad · Accepted solution]

In Power Query Editor, pick Ex 1, 2,3 columns, right click-unpivot columns

Then, create a score measure Sum(Value) or Avg(Value)
Then Rank measure: 

[GeoSans]

I created a mesure called Score doing Sum(Values) but it returns me the same number

[GeoSans]

Hi Olgad!

I would like to see it in a table ordered by from the hardest to the easiest ones but I'm one to visualize it in a different way

[olgad]

How would you like to display it in your report? What shall be the output, please? Exercise 2 is the hardes, 1 is following and 3 or?