Forum Discussion

PaulinRoc's avatar
PaulinRoc
Frequent Visitor
3 years ago
Solved

Rank by a column excluding another column

Hello to all, I would like to create a ranking column that ranks wines according to the average score obtained. Here is my dataset :   Here is my objective:     The problem is th...
Need Help
  • onurbmiguel_'s avatar
    onurbmiguel_
    3 years ago

    Hello 

     

    Try this measure: 

    Rank = 
var _rank =
RANKX(
    ALLSELECTED('Wine Score'),
    CALCULATE(
        sum('Wine Score'[Score]),
        ALLEXCEPT('Wine Score','Wine Score'[Wine])
    ),
    ,
    DESC,
    Dense
    )
return 
_rank

     

     

    Best regards

    Bruno Costa | Solution Supplier

     

    Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

    Take a look at the blog: PBI Portugal 

     

PaulinRoc's avatar
PaulinRoc
Frequent Visitor
3 years ago

Thank you for your answer.
But now I would like the row to take into account the type of wine (red or white).

 


How to make the rank taking into account the type of wine but without taking into account the taster?

onurbmiguel_'s avatar
onurbmiguel_
Power Participant
3 years ago

Hello 

My suggestion is that separate in to two tables :

My opinion is that like this will give more clear information to the users. 

All together it will not very clear.  

 

Best regards

Bruno Costa | Solution Supplier

 

Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

Take a look at the blog: PBI Portugal 

  • PaulinRoc's avatar
    PaulinRoc
    Frequent Visitor
    3 years ago

    Thanks a lot!