topic Re: How to Count Duplicate Cells and Return "1" for First Occurences and "0" for others in DAX Commands and Tips

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

Anonymous — Mon, 12 Jun 2023 14:57:09 GMT

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?

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

tamerj1 — Mon, 12 Jun 2023 15:10:09 GMT

Hi Anonymous
Do you have a date or index column?

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

Anonymous — Mon, 12 Jun 2023 15:19:01 GMT

Hi tamerj1,

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

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

tamerj1 — Mon, 12 Jun 2023 15:23:47 GMT

Anonymous

Please try

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