Highlighting duplicate values in a power BI table

Hi Kaskazi_Network ,

You can group by Outlet and add a record count as a calculated column.

Consequently, you could filter your visual to only show records where this record count > 1.

Alternatively, you can use the summarizecolumns function in DAX which actually does the same as the group by but won't store the data in memory. More information on this function you can find here: https://docs.microsoft.com/en-us/dax/summarizecolumns-function-dax

Was my answer anywhere helpful?

Show your appreciation by simply marking my reply as solution or throw it a kudo. 🙂

Hop on the data train and get connected @LouSegers

Hi Kaskazi_Network 

You can use the distinct count to calculate the visits whether more than once, output the value as calculated column. and then use the conditional firmatting to highlight it. 

Please share the dummy pbix with expected results disclosed if you'd like us to draw it up for you.