Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Shreeram04
Resolver III
Resolver III

Check Duplicate in a column

Hi All,

 

I need to compare two column values.

 

For example in the given below table

TypeID
Nationala
Nationalb
Nationala
Privatea
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

TypeIDFlag
Nationala1
Nationalb0
Nationala1
Privatea0
Private c0

 

Please help to identify a solution. Thanks in advance.

1 ACCEPTED SOLUTION
DataInsights
Super User
Super User

@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

 

DataInsights_0-1670945254106.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
DataInsights
Super User
Super User

@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

 

DataInsights_0-1670945254106.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.