Forum Discussion

HVAC_Specialist's avatar
HVAC_Specialist
Regular Visitor
5 months ago
Solved

Highlight duplicate values in a table

Hello Everybody, I need some help to highlight duplicate values in a table. I tried may offered solutions but I don't get it working, the measures and calculated columns (eg the offered and found sol...
Need Help
  • v-tejrama's avatar
    v-tejrama
    5 months ago

    Hi HVAC_Specialist ,

     

    Yes, this is now correct. The main difference from your previous result is that the Value column is no longer aggregated, so the duplicate check occurs at the row level as intended. The value 100 is appropriately flagged as a duplicate when it appears multiple times within the current filter context, while other values are not flagged. This matches the expected behavior for a measure-based approach, as it evaluates only the visible rows in the table rather than the entire dataset.

    Please find the attached PBIX and Screenshort file for your reference.


    Thank you.