DAX RANKX start at 2 instead of 1 in ASC but fine in DESC.

[HariBPujari]

I write a DAX measure:

Rank by Value =

IF(ISINSCOPE(Sheet1[Value]),

RANKX(

    ALLSELECTED(Sheet1[Value]),

    [Total Value],,ASC,Dense

))

but rank start at 2 instead of 1 in ASC, but if i put DESC instead of ASC, it start at 1. I am not getting what is going on with my DAX code.

Here is Sample Data:

Item	Value
A	100.00
A	200.00
A	300.00
A	400.00
A	500.00
A	600.00
A	700.00
A	800.00
A	900.00
A	1,000.00
B	1,100.00
B	1,200.00
B	1,300.00
B	1,400.00
B	1,500.00
C	1,600.00
C	1,700.00
D	1,800.00
D	1,900.00
E	2,000.00

and here is the result, you can see in every Item it start at 2:

Can anyone help me?

[ThxAlot · Accepted solution]

Rank by Value.pbix

[HariBPujari]

Thanks you, it worked. But still I am not getting what was wrong with my measure. Can you please explain?