Rank by a column excluding another column

[PaulinRoc]

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 that the ranking is done according to the taster, which I don't want.

After a few days of research, I ask my question on this forum.

Thanks to you,
have a nice day

[onurbmiguel_ · Accepted solution]

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]

Hello,
I am coming back to you because my problem is not solved.
I would like to create a column containing my ranks and not a measure. I would also like the ranks not to be duplicated (if two wines have the same average, they should not have the same rank).

Thanks for your help

[PaulinRoc]

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

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]

Thanks a lot!