Forum Discussion

cruncher's avatar
cruncher
Icon for Helper II rankHelper II
1 year ago
Solved

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's avatar
    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's avatar
v-kathullac
Icon for Community Support rankCommunity Support
1 year ago

Hi @cruncher  ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya

cruncher's avatar
cruncher
Icon for Helper II rankHelper II
1 year ago

It didn't work. Please try with pbix file I attached earlier

  • v-kathullac's avatar
    v-kathullac
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi cruncher ,

     

    can you check with below mentioned measure and let us know if you need any further assistance. for your reference am attaching a screenshot as well.

    Customer_Rank 1 = 
VAR SelectedStatus = VALUES(Sales[Status])
RETURN
RANKX(
    FILTER(
        ALLSELECTED(Sales),
        Sales[Rank Source] = "Yes" &&
        Sales[Source] IN VALUES(Sales[Source]) &&
        Sales[Status] IN SelectedStatus
    ),
    CALCULATE(SUM(Sales[Sales])),
    ,
    DESC,
    DENSE
)

     

    Regards,

    Chaithanya.. 

    • cruncher's avatar
      cruncher
      Icon for Helper II rankHelper II
      1 year ago

      Thanks for trying but it still not giving correct rank.

       

       

      • v-kathullac's avatar
        v-kathullac
        Icon for Community Support rankCommunity 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.