Forum Discussion

clem312's avatar
clem312
Resolver I
4 years ago
Solved

Ranking, equal issue

Hi,   I have a ranking with equals values on 3rd position :   I want to display data in a matrix with categories (code_lib) sort by decreasing @Note RANKX(VALUES(code[code_lib]), CALCULATE...
Need Help
  • Natallia_23's avatar
    Natallia_23
    4 years ago

    Hello,

     

    The formula cannot assign different ranks (3,4,5) to the same values.
    You can add an index column to the table (in PowerQuery). Then, in the formula for the rank, add to the column for which the rank is index / large number. So the numbers will insignificantly differ and the rank will be in order.

    [your column] + [index]/100000

Natallia_23's avatar
Natallia_23
Resolver I
4 years ago

Hello,

 

The formula cannot assign different ranks (3,4,5) to the same values.
You can add an index column to the table (in PowerQuery). Then, in the formula for the rank, add to the column for which the rank is index / large number. So the numbers will insignificantly differ and the rank will be in order.

[your column] + [index]/100000