How to Count Duplicate Cells and Return "1" for First Occurences and "0" for others

[Anonymous]

Hi everyone, are you guys doing well?

I have a complicated challenge here to add a new column to my table,

Basically, I need to count duplicate ID's, and after that, I need to write "1" into one of the X rows that are duplicates,

For example, as in my table below, the ID "X1" repeats 4 times, then I need to write "1" as result into any row, and "0" for the remaining ones,

I have tried to use the expressions Countrows with Earlier function, but It will always give me just the repetition count,

 COUNTROWS(FILTER('Table', EARLIER('Table'[ID]) = 'Table'[ID] ) )

Could you guys help me out with this challenge?

[tamerj1]

Hi @Anonymous 
Do you have a date or index column?

[Anonymous]

Hi tamerj1,

Yes, I have a column date, but the column index no,

[tamerj1 · Accepted solution]

@Anonymous 

Please try

Expected Result =
IF (
'Table'[Date]
= CALCULATE ( MIN ( 'Table'[Date] ), ALLEXCEPT ( 'Table', 'Table'[ID] ) ),
1,
0
)