Identifying duplicate entries in a column, shown in a report table

[mattsampson]

Hi Guys,

I've got a report with a table of student data that has come in via a form.

Some students have been annoying and submitted the form twice and I need to be able to see this within the PowerBI report rather than pull this into excel and do a conditional format on that column. 

I want to highlight using a background colour ideally, the rows (or at least the UserID field) for the duplicates. 

Name	Year	Option1	Option2	UserID
Joe	Year 10	Maths	Science	joe123
Joe	Year 10	Maths	English	joe123
Peter	Year 7	Music	Art	peter123
Peter	Year 7	Music	Art	peter123
Matt	Year 8	French	English	matt123
John	Year 8	Music	Art	john123
Rachel	Year 9	Maths	English	rachel123
Emily	Year 10	English	Science	emily123

Thanks in advance

Matt 

[mahoneypat · Accepted solution]

You can use an expression like this to give you the count of entries with the same userid (and then you can sort/filter by it to find multiples).  I called the table Students, so replace that with your actual table name.

Count Same ID =
CALCULATE (
COUNT ( Students[UserID] ),
ALL ( Students ),
Students[UserID] = EARLIER ( Students[UserID] )
)

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[jthomson]

Should be possible using a countrows formula in a conditional column using the id field as a basis, you can then conditionally format/sort on that new column