Problem with simple rankx

[gluizqueiroz]

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 is the following:

Measure RANKX = RANKX(ALLSELECTED(BI_Sales[SalesPerson]); [Sum_Sales]))

Sum_Sales = SUM(BI_Sales[Sales])

I have done a simple RANK like this in other projects and it works. 
Someone knows what can cause it?

[Ashish_Mathur · Accepted solution]

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]

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

[TCarrasquillo]

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