Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Rank Skip Not Working

I'm ranking a column of values that I originally had as Dense for ties but decided to switch to Skip. This however did not change the outcome of the data for some reason. I have tried creating a new column, restarting the app and my computer and none of them seem to work. Does anyone have experience with this and how to solve it?

 

Code:

Rank =
RANK(
    SKIP,
    ALLSELECTED(Table[Original Rank], Table[Date 1], Table[Score], Table[Date 2]),
        ORDERBY(
           Table[Original Rank], ASC,
            Table[Date 2], ASC,
            Table[Date 1], ASC,
            Table[Score], DESC
))
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    It can only accept one condition, but you can have the conditions you need worked out before that happens. For example, [Value]=A*0.2+B*0.3+C*0.1+D*0.4. This also sorts the four conditions in a way.

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    2 years ago

    Anonymous , Please try using this measure

     

    dax
    Rank =
    RANKX(
    ALLSELECTED(Table),
    Table[Original Rank],
    ,
    ASC,
    DENSE
    )

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Can RankX accept multiple ranking criteria? The Skip in RankX works but I need all 4 criteria to be taken into account for each value or else it just spits out the "Original Rank" column.

       

      The code works perfectly except it won't do skip for ties, even with Skip specified.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous ,

         

        It can only accept one condition, but you can have the conditions you need worked out before that happens. For example, [Value]=A*0.2+B*0.3+C*0.1+D*0.4. This also sorts the four conditions in a way.

         

        Hope it helps!

         

        Best regards,
        Community Support Team_ Scott Chang

         

        If this post helps then please consider Accept it as the solution to help the other members find it more quickly.