topic Re: RANKX not working properly when applying filter in DAX Commands and Tips

RANKX not working properly when applying filter

aleivar — Thu, 20 Apr 2023 22:12:22 GMT

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.

Re: RANKX not working properly when applying filter

FreemanZ — Thu, 20 Apr 2023 22:35:04 GMT

hi aleivar

try to change ALL to ALLSELECTED.

Re: RANKX not working properly when applying filter

aleivar — Thu, 20 Apr 2023 23:28:50 GMT

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