Count duplicate values and number them as 1,2,3.

[Anonymous]

Can any one help me for DAX formula to number the duplicate values as 1,2,3... in the 2nd column

I have tried with this DAX formula in a new column {Double = IF(CALCULATE(COUNT('Rejection'[URN]),FILTER('Rejection','Rejection'[URN]=EARLIER('Rejection'[URN])))>1,1,0)}, but the result is not matched what i have expected.

URN-         Duplicate Numbering
---------------------------
1007171-          1
1007172-          1
1007172-          2
1007172-          3
1007175-          1
1007175-          2
1007177-          1

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous

Please see the attached file

We need an assitant field/ column to do this numbering.

So first  add a calculated column

SupportingColumn =
RANDBETWEEN ( 1, 100 )

Then we can use this formula to get desired Duplicate Numbering

Duplicate_Numbering =
RANKX (
    FILTER ( Table1, Table1[URN] = EARLIER ( Table1[URN] ) ),
    Table1[SupportingColumn]
)