Check Duplicate in a column

[Shreeram04]

Hi All,

I need to compare two column values.

For example in the given below table

Type	ID
National	a
National	b
National	a
Private	a
Private	c

I need to compare two columns (Type and ID) if values are repeated I need to put 1 otherwise 0, example the combination of national-a is repeated two times so I need to put value 1 for both these columns and for national-b it should be 0 because it is not repeated.

The final table should be like this

Type	ID	Flag
National	a	1
National	b	0
National	a	1
Private	a	0
Private	c	0

Please help to identify a solution. Thanks in advance.

[DataInsights · Accepted solution]

@Shreeram04,

Try this calculated column:

Flag = 
VAR vType = Table1[Type]
VAR vID = Table1[ID]
VAR vRowCount =
    COUNTROWS ( FILTER ( Table1, Table1[Type] = vType && Table1[ID] = vID ) )
VAR vResult =
    IF ( vRowCount > 1, 1, 0 )
RETURN
    vResult