Forum Discussion
Solved
Problem with simple rankx
SalesPerson Sales Measure Rankx Jonh 100 1 Mary 80 2 Tom 80 3 Eli 70 4 Clark 50 5 Anne 40 6 I wanna make a simple RANKX but I'm having some problems, my RANKX...
Hi,
If you are wondering why the rank is the same, it is probably because there are decimal numbers in the sales figures. Check your source data.
Not Sure , I for the issue completely. Given all or table name instead of all selected
Measure RANKX = RANKX(ALL(BI_Sales[SalesPerson]); [Sum_Sales]))
Measure RANKX = RANKX((BI_Sales); [Sum_Sales]))
Refer for rank
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures