Removing duplicates in report level

[Anonymous]

Hello All,

I have a table chart where I am showing agentname and tickets.

I see I am getting some duplicates agent names in the report.

I need to delete that in the report level only .(Not in tranformation data)

Could any one please help how to do

[v-jingzhang]

Hi @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.

[Idrissshatila · Accepted solution]

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/1583045

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin