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

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 

     

5 Replies

  • onurbmiguel_'s avatar
    onurbmiguel_
    Power Participant
    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

      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