Forum Discussion
Removing duplicates in report level
Hello Anonymous ,
this should be handled in transformation data or in the data source, but if you want check these solutions
https://community.powerbi.com/t5/Desktop/Remove-Duplicates-Report-View/m-p/2440959
https://community.powerbi.com/t5/Developer/Remove-duplicates-from-a-report/m-p/1583045If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Community SupportHi Anonymous
If an agentname has more than one tickets in your original table, this is the expected result when you select "Don't summarize" for "Ticket" field in the table visual. In this scenario, to display every agentname once, you can expand the drop-down arrow next to "Ticket" column in Values well of the table visual and select another appropriate aggregation type for it instead of "Don't summarize". Hope this helps.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.