Rankx function is behaving weird when used in table with extra columns and Slicers

Hi Experts. I am having a hard time understanding dax evaluation context in Rankx function. I want to rank the customers based on sales. These are the steps I have followed. Step 1: Creating ...

DAX

RANKX

v-kathullac

1 year ago

Hi cruncher ,

Can you try with below dax measure attaching the screenshot for your reference.

Customer_Rank 3 = 
RANKX(
    FILTER(
        ALLSELECTED(Sales),
        Sales[Rank Source] = "Yes"
            && Sales[Source] IN VALUES(Sales[Source])
    ),
    CALCULATE(SUM(Sales[Sales])),
    ,
    DESC,
    DENSE
)

Regards,

Chaithanya.

v-kathullac

Community Support

1 year ago

Hi cruncher ,

Can you try with below dax measure attaching the screenshot for your reference.

Customer_Rank 3 = 
RANKX(
    FILTER(
        ALLSELECTED(Sales),
        Sales[Rank Source] = "Yes"
            && Sales[Source] IN VALUES(Sales[Source])
    ),
    CALCULATE(SUM(Sales[Sales])),
    ,
    DESC,
    DENSE
)

Regards,

Chaithanya.

cruncher

Helper II

1 year ago

Thanks v-kathullac It is working as expected. Much appreciated for your effort.

Forum Discussion

Rankx function is behaving weird when used in table with extra columns and Slicers