Forum Discussion

wollensack's avatar
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 Fo...
Tips and Tricks
  • DOLEARY85's avatar
    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 👍

wollensack's avatar
wollensack
Frequent Visitor
3 years ago

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