Relate tables

[Oros]

Hello,

I have 3 tables (DOLLAR and QTY tables are related with the third table PRODUCT).

The DOLLAR and QTY columns are correct, but as soon as I bring in the CUSTOMER column the QTY for each customer always shows the TOTAL QTY for all customers.  How do I relate the CUSTOMER from the 2 tables?  Thanks.

Here is the sample pbix:

SAMPLE pbix

Here are the screenshots:

(this is correct)

(when CUSTOMER is added, the  QTY is NOT correct)

highlighted in green is correct

(QTY duplicated per line)

[Ashish_Mathur · Accepted solution]

Hi,

Create a single column table of all unique customers.  Create a Many to One relationship from the Qty and Dollar Table to the Customer Table.  To your visual, drag Customer from the Customer Table.

Hope this helps.

[ThxAlot · Accepted solution]

[Oros]

Thanks @ThxAlot ,

This work as well!

[Ashish_Mathur · Accepted solution]

Hi,

Create a single column table of all unique customers.  Create a Many to One relationship from the Qty and Dollar Table to the Customer Table.  To your visual, drag Customer from the Customer Table.

Hope this helps.

[Oros]

Thanks @Ashish_Mathur ,

This works!

[aj1973]

Hi @Oros 

Change the relationship to both

[Oros]

Hi @aj1973 ,

Thank you for your quick reply.  I changed the relationship as you indicated.  But it looks like only the total is correct. COuld it be because the CUSTOMER from the DOLLAR and QTY tables must also be related?  Thanks again.

The QTY lines are duplicated and do not equal the total qty of 2,165.38.

The matrix table is also not correct because of duplicated QTY.

In Excel Pivot Table, this are the correct numbers.

[aj1973]

@Oros New Update:

Use CUSTOMER from the DOLLAR Table instead

And Use Product from the Dollar Table

[Oros]

Hello @aj1973 ,

Unfortunately, the result is still incorrect.  The QTY column still shows duplicate values.  How do we avoid the duplicate values and show the correct values instead?  Thanks.

[aj1973]

[Oros]

Hi @aj1973 ,

Thanks again for your reply. 

Unfortunately, the duplicate (incorrect) values still show up in the QTY column.