Issue with RANKX with filters

[Rachid1679]

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 another visual, the ranking is wrong (for some customers). 

The DAX measure is :

RANKX(ALL('Table'[customer]),[Sales])

Enclosed a data simplified. 

 

Thank you for the support. 

[Anonymous · Accepted solution]

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 · Accepted solution]

Hi,

I used these measures

S = SUM(Data[Sales])

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

Hope this helps.

[Anonymous · Accepted solution]

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.