Forum Discussion
Repetead values
Hi everyone,
I have created bridge relationship tables to connect my Budget and Sales tables to my Customer lookup table. But it seems that when I try to compare Sales vs Budget per client, the values are repeated with every customer as shown in the second graph.
The following is what I need to fix:
I appreciate some guidance to fix this mistake and finish my report.
Thank you.
caurueta , Why you have two table for sales customer and budget customer. Both these should join directly to customer
refer: https://www.youtube.com/watch?v=Bkf35Roman8
https://www.seerinteractive.com/blog/join-many-many-power-bi/
2 Replies
- amitchandak
Super User
caurueta , Why you have two table for sales customer and budget customer. Both these should join directly to customer
refer: https://www.youtube.com/watch?v=Bkf35Roman8
https://www.seerinteractive.com/blog/join-many-many-power-bi/
- Ashish_Mathur
Super User
Hi,
Share the link from where i can download your PBI file.