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.
I'm not sure what problem you are having. Did you want the ranking to be tied between the 2 that have the same sales? I'm pretty sure that you can specify the ties portion of a rankx measure with Dense or Skip
so the measure would look like..... Rankx(all selected(table); [measure],,dense))
I'm pretty sure that dense is the one that would give you 2 Rank 2's but I'd try both options and see what's better