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"CustomerIDImpacted CodeStatusAge in DaysOpenedResolvedSLA MetHappy LolliesBI461BI461Closed314/03/202316/03/2023NO SLAHappy LolliesBI479BI479Resolved230/03/202331/03/2023NO SLAHappy LolliesBI372BI372Closed56/03/202310/03/2023NO SLAHappy LolliesBI338BI372Pending1830/03/2023 NO SLAHappy LolliesBI263BI338Resolved527/03/202331/03/2023SLA MetHappy LolliesBI729BI263Resolved21/03/20232/03/2023SLA MetHappy LolliesBI483BI263Pending3414/03/2023 NO SLAHappy LolliesBI207BI207Pending2028/03/2023 NO SLAHappy LolliesBI818BI818In Progress471/03/2023 SLA MissedHappy LolliesBI839BI355Closed16/03/20236/03/2023NO SLAHappy LolliesBI272BI355Closed28/03/20239/03/2023NO SLAHappy LolliesBI355BI355Closed115/03/202315/03/2023SLA MetHappy LolliesBI526BI526Closed109/03/202318/03/2023SLA MetHappy LolliesBI379BI379Closed115/03/202315/03/2023SLA Met Frank Wollensack

Hi, you can set up a calculated column: Column = var _distinct = 'Table (3)'[test]returnCALCULATE( 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 👍

wollensack

Frequent Visitor

3 years ago

Solved

Highlight Fields when duplicate value found in table

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

Tips and Tricks

DOLEARY85
3 years ago
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 👍

Forum Discussion

Highlight Fields when duplicate value found in table

3 Replies

Related content

Highlight duplicate values in a table

Highlighting groups of duplicates

Duplicate ranking

remove duplicate value within a row

Removing Duplicates