Repetead values

[caurueta]

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.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[amitchandak · Accepted solution]

@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/