Duplicate data in table visual

[HB13]

Hi all 

I have a dim table with lots of duplicate entries that can only join my fact table in a many to many relationship.

I created a simple table in my report with most of the information coming from the fact table, however when I bring the column I need from the dim table then it creates duplicates for a few rows in my visual.

This is fine in desktop because the totals on the visual are correct, however when I export this visual to excel and calculate the sum of all my rows then it is much larger than PBI Desktop as the duplicates are present in the export.

I have tried removing duplicates from the dim table in Power Query and the relationship does become a one to many but the export total is still grossly incorrect. 

I hope this make sense. Does anyone have a solution for this please?! I don't know what else to try. 

Many many thanks 

[Anonymous]

Hi @HB13 ，

May I ask if your problem has been solved? Did PC2790's post above help you? If any of the posts are helpful, then please consider Accepting it as a Solution to help other members find it faster. Many thanks!

If this doesn't work for you, would you mind providing some data that does not contain private information?

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[PC2790]

Have you considered using a bridge table to deal with many to many relationship?

Here, refer How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive