Request for help with RANKX function (DAX measure)

EglanVer,

Try this measure using the RANK function. It's preferred over RANKX in most cases.

RANK_FINAL =
VAR SourceTable =
    ADDCOLUMNS (
        ALLSELECTED ( APRIL_2024_PURCHASES[BRANDS] ),
        "@ShareOfQuantity", [Share of quantity]
    )
VAR Result =
    RANK ( DENSE, SourceTable, ORDERBY ( [@ShareOfQuantity], ASC ) )
RETURN
    Result

https://www.sqlbi.com/articles/introducing-the-rank-window-function-in-dax/