Highlight Fields when duplicate value found in table

[wollensack]

Hello All,

I have a power Bi Table visual, I want to highlight any records in the field "Impacted Code" which has a value duplicated.
I tried to create a measure and link it using "Conditional Formatting" but unfortunately it failed. Hope someone can assist me.
Table = "Faults"

Customer	ID	Impacted Code	Status	Age in Days	Opened	Resolved	SLA Met
Happy Lollies	BI461	BI461	Closed	3	14/03/2023	16/03/2023	NO SLA
Happy Lollies	BI479	BI479	Resolved	2	30/03/2023	31/03/2023	NO SLA
Happy Lollies	BI372	BI372	Closed	5	6/03/2023	10/03/2023	NO SLA
Happy Lollies	BI338	BI372	Pending	18	30/03/2023		NO SLA
Happy Lollies	BI263	BI338	Resolved	5	27/03/2023	31/03/2023	SLA Met
Happy Lollies	BI729	BI263	Resolved	2	1/03/2023	2/03/2023	SLA Met
Happy Lollies	BI483	BI263	Pending	34	14/03/2023		NO SLA
Happy Lollies	BI207	BI207	Pending	20	28/03/2023		NO SLA
Happy Lollies	BI818	BI818	In Progress	47	1/03/2023		SLA Missed
Happy Lollies	BI839	BI355	Closed	1	6/03/2023	6/03/2023	NO SLA
Happy Lollies	BI272	BI355	Closed	2	8/03/2023	9/03/2023	NO SLA
Happy Lollies	BI355	BI355	Closed	1	15/03/2023	15/03/2023	SLA Met
Happy Lollies	BI526	BI526	Closed	10	9/03/2023	18/03/2023	SLA Met
Happy Lollies	BI379	BI379	Closed	1	15/03/2023	15/03/2023	SLA Met

Frank Wollensack

[wollensack]

thankyou all for the help , sadly only could accept one solution 

[Ahmedx]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RhzIi2n_Qrzo9MOHs?e=TlFIEO

[DOLEARY85 · Accepted solution]

Hi,

you can set up a calculated column:

Column =

var _distinct = 'Table (3)'[test]

return

CALCULATE(

    COUNTROWS('Table (3)'),ALL('Table (3)'),

    'Table (3)'[test] = _distinct

)

then apply that to conditional formatting:

hope this helps

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍