RANKX not working when slicer selection is made

[Sage2019]

Hi , I am trying to create a rank measure that ranks a list of items based on their ID which is unique and incremented. However, the RANK Measure num is repeated for all items when a selection is made in the slicer. How can I fix this? 

rank measure = RANKX(ALLSELECTED(cars),calculate(SUM(cars[carID])),,ASC)

[Anonymous · Accepted solution]

Hi @Sage2019 

I followed your method to create the following table and measure formula, which works fine on my Power BI desktop

rank measure = RANKX(ALLSELECTED(cars),calculate(SUM(cars[carID])),,ASC,Dense)

If you don't want your rank measure to change with your slicer selection, you can try using the following DAX

Rank Measure1 = 
RANKX(
    ALL(cars), 
    CALCULATE(SUM(cars[carID])),
    ,
    ASC,
    DENSE
)

Best Regards,

Jayleny

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