Forum Discussion

gluizqueiroz's avatar
gluizqueiroz
Icon for Resolver I rankResolver I
7 years ago
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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    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.

TCarrasquillo's avatar
TCarrasquillo
Icon for Helper II rankHelper II
7 years ago

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