Remove duplicates from data in a filtered table visual?

[BoundedInANutshell]

Hi everyone,
I have a simple table visual that users filter using a 'Company Name' slicer and a date timeline. They then wish to remove duplicates from the filtered results, using 'Email Address' as the column to identify the duplicates. Any ideas how I could achieve this. I can't remove duplicates in the model because it is dependent on the filters chosen by the user (duplicates will be different depending on the company name and date range selected). Any suggestions greatly appreciated. Thanks in advance.
Jason

 

[Matt Allington]

I assume this is Power BI. If there are duplicate, then it must be that some of the columns in the table have different values. So which one should be removed? Anyway, you could try putting a topN on the email, and keep the top 1