Forum Discussion

Rachid1679's avatar
Rachid1679
Regular Visitor
2 years ago
Solved

Issue with RANKX with filters

Hello team I need your support regarding the dax measure RANKX. When using the measure in a matrix i get the correct ranking by customer. However, when selecting a specific customer from a slicer or...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  Rachid1679 ,

     

    You can try the following dax

    Rank =
RANKX(ALL('Table'),CALCULATE(SUM('Table'[Sales])),,DESC)

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    I used these measures

    S = SUM(Data[Sales])
    Rank = RANK(DENSE,ALL(Data[Customer]),orderby([S],DESC))

    Hope this helps.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  Rachid1679 ,

 

You can try the following dax

Rank =
RANKX(ALL('Table'),CALCULATE(SUM('Table'[Sales])),,DESC)

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.