Color code duplicate numbers

[inglexjc]

Is there a way to color code when a Client ID is showing up more than once in the data?

Example

Client Name	Client ID	CAS_ID	AGE	Removal Date
Doe, Jane	274	178	13	1/20/2022
Doe, Jane	274	178	13	11/13/2020
Smith, K	315	177	8	1/17/2023
Smith, K	315	177	8	7/14/2023
Doe, John	282	17701	16	2/13/2023
Doe, John	282	17701	16	5/1/2014
Non, Duplicate	574	254	14	10/27/2015

So have the Client ID be RED if it's showing in the report more than once.

[NaveenGandhi · Accepted solution]

Hi

Below dax should do the job, Add conditional formatting over client id.

Color code =

VAR Check = CALCULATE(count('Table'[Client ID]),ALLEXCEPT('Table','Table'[Client Name]))

RETURN if(Check>1,"RED","")

 If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!