topic Re: Rank Skip Not Working in DAX Commands and Tips

Rank Skip Not Working

Anonymous — Fri, 28 Jun 2024 14:48:33 GMT

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

))

Re: Rank Skip Not Working

bhanu_gautam — Fri, 28 Jun 2024 17:36:09 GMT

Anonymous , Please try using this measure

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

Re: Rank Skip Not Working

Anonymous — Fri, 28 Jun 2024 17:54:44 GMT

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.

Re: Rank Skip Not Working

Anonymous — Mon, 01 Jul 2024 07:16:59 GMT

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.