Forum Discussion
gluizqueiroz
Resolver I
7 years agoProblem 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...
- 7 years ago
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.
amitchandak
Super User
7 years agoNot 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