Forum Discussion

Salle's avatar
Salle
Advocate I
3 years ago
Solved

Strange RANKX sorting

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?

[help needed]
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

  • Salle's avatar
    Salle
    Advocate I
    3 years ago

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