Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Duplicates

Hi: Using the Table Relationships window, what is the best way to eliminate duplicate records appearing in your visualizations? Thanks! John
Need Help
  • Anonymous's avatar
    Anonymous
    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's avatar
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's avatar
    Anonymous
    Not applicable
    4 years ago

    They don;t appear in PQ -- only in the report itself.

    • Anonymous's avatar
      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"!  🙂