topic Strange RANKX sorting in DAX Commands and Tips

Strange RANKX sorting

Salle — Mon, 22 May 2023 19:24:56 GMT

Simple setup with Table "Result" Column "Size" (decimal formatted), slicer ("Sample Name" from Table2 Parameter).

1 to many relationship setup between Parameter and Result table.

Rank Size = RANKX (ALL(Result), CALCULATE(SUM(Result[Size])),,ASC, Dense)

Result below:

Is it the filter context that is impacting or what is happening?

Re: Strange RANKX sorting

Anonymous — Wed, 24 May 2023 05:40:58 GMT

Hi Salle ,

I suggest you to try code as below to create a measure.

Rank Size = VAR _SIZE = CALCULATETABLE ( VALUES ( Result[Size] ), ALLSELECTED ( Result ) ) VAR _ADDRANK = ADDCOLUMNS ( _SIZE, "RANK", RANKX ( _SIZE, [Size],, ASC, DENSE ) ) RETURN SUMX ( FILTER ( _ADDRANK, [Size] = MAX ( Result[Size] ) ), [RANK] )

Result is as below.

Best Regards,
Rico Zhou

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

Re: Strange RANKX sorting

Salle — Thu, 08 Jun 2023 11:59:24 GMT

Anonymous thanks for the reply, I have tested and it seems to be working as expected. Thanks!