Hi:
Using the Table Relationships window, what is the best way to eliminate duplicate records appearing in your visualizations?
Thanks!
John
Solved! Go to Solution.
I figured it out. I simply removed the relationship of one table and joined that table to a different table. That was "it"! 🙂
@jellis1971 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.
Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@jellis1971 I would recommend removing duplicated in PQ.
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.
Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
They don;t appear in PQ -- only in the report itself.
I figured it out. I simply removed the relationship of one table and joined that table to a different table. That was "it"! 🙂
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
User | Count |
---|---|
389 | |
103 | |
66 | |
54 | |
49 |
User | Count |
---|---|
372 | |
120 | |
82 | |
68 | |
57 |