Hi:Using the Table Relationships window, what is the best way to eliminate duplicate records appearing in your visualizations?Thanks!John

I figured it out. I simply removed the relationship of one table and joined that table to a different table. That was "it"! 🙂

Duplicates | Microsoft Fabric Community

parry2k
Super User
4 years ago
Anonymous I would recommend removing duplicated in PQ.

✨ Follow us on LinkedIn and to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
- Anonymous
  Not applicable
  4 years ago
  They don;t appear in PQ -- only in the report itself.
  - Anonymous
    Not applicable
    4 years ago
    I figured it out. I simply removed the relationship of one table and joined that table to a different table. That was "it"! 🙂
parry2k
Super User
4 years ago
Anonymous hmmm, not sure. It will be easier you share some sample data, with the relationship and if any DAX you are using and where you see the duplicated. Hard to figure out otherwise.