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 👍

DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
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 👍