Forum Discussion
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 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.
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.
Hi,
I used these measures
S = SUM(Data[Sales])Rank = RANK(DENSE,ALL(Data[Customer]),orderby([S],DESC))Hope this helps.
2 Replies
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.
Hi,
I used these measures
S = SUM(Data[Sales])Rank = RANK(DENSE,ALL(Data[Customer]),orderby([S],DESC))Hope this helps.