Rank Skip Not Working

[Anonymous]

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

))

[bhanu_gautam]

@Anonymous , Please try using this measure

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

[Anonymous]

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.

[v-tianyich-msft · Accepted solution]

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.