Forum Discussion
HVAC_Specialist
5 months agoRegular Visitor
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...
- 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.
ryan_mayu
5 months agoSuper User
what filter are you using?
could you pls provide some sample data (not the screenshot) and the expected output?