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 

     

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

        Thanks a lot!

  • 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