Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Detect errors by comparing row values in power BI

Hello, I have data like follows:     Here I'm trying to detect rows in which I have errors similar to this one framed in red. In my client file I have  John Doe  with email address : joh...
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You could build table with the unique combinations of client ID, email and name like

Unique values =
SUMMARIZE ( 'Table', 'Table'[Client ID], 'Table'[Email', 'Table'[Name] )

Then build a measure

Num unique values = COUNTROWS( 'Unique values' )

Create 3 separate table visuals, one for each column of the unique values table and add the measure. Filter the tables so that they only show when the measure is greater than 1 and that should show all the entries where there are duplicates.