Strange RANKX sorting

[Salle]

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?

[Salle]

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

[Anonymous · Accepted solution]

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.