RANKX not working properly when applying filter

[aleivar]

Hi,

My RANKX function is not working properly when I apply a Brand filter. For example, without filters I get the following rank

But when I apply a Brand filter, to select only Pure Sunfarms, Redecan, and Good Supply the ranking changes:

My formula is:

Rank (Total Sales) Brand = 
IF(
    HASONEVALUE(
        'OCS-daily-2018-2023'[brand]
    ),
    RANKX(
        ALL(
            'OCS-daily-2018-2023'[brand]
        ),
        [Total Sales],
        ,
        DESC,
        Dense
    )
)

and my model looks like this:

Any help is greatly appreciated.

[aleivar]

Hi, I tried that but it's not working. I want to keep the same rank:
1,2,3 even when applying the brand filter

[FreemanZ]

hi @aleivar 

try to change ALL to ALLSELECTED.