Highlight duplicate values of table column based on selection data

[Rinosh]

Hi,

Need help to highlight the duplicate values of column ( Part number)  based on selection critera.( Cost center)

Eg :- Under lined part number (4002690132) to get hilighted in this selection criteria ( HMV--FZC08DT)

[Rinosh · Accepted solution]

Hi,

Solved the problem by creating a calculated column for couting duplicate values

Duplicate values = COUNTROWS(FILTER('Table',EARLIER('Part No') =('Table'[Part No]) && EARLIER('Table'[Costcenter])='Table'[Costcenter]))

Futher applied conditional formating based on duplicate values.

Conditional formating --> Icons

Rules --> Value only

 Summarization  --> Sum of duplicate values

Rule -->

If Value > 1 Number & Less <= Max Number  , then select color.

[v-luwang-msft]

Hi  @Rinosh ,

Pls share your pbix file ,remember to remove confidential data.

Best Regards

Lucien

[Rinosh]

Hi,

Can you please share your E mail id. i could not upload the PBIX file