Forum Discussion
Highlight duplicate values in a table
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.
Hi HVAC_Specialist ,
Thank you Zanqueta for sharing your response!
Just checking has your concern been resolved? If the provided answer helped, please confirm so others can benefit from the solution too.
Thank you.
Hello Zanqueta, the duplicate numbers are not highlighted.
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.Hi HVAC_Specialist ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.