Forum Discussion

GeoSans's avatar
GeoSans
New Member
2 years ago
Solved

Ranking columns

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 i...
Need Help
Show and Tell
Tips and Tricks
  • olgad's avatar
    olgad
    2 years ago

    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: 

     

     

     

olgad's avatar
olgad
Resident Rockstar
2 years ago

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's avatar
    GeoSans
    New Member
    2 years ago

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