Relationship Issues

[afedianine]

Hi! I have an issue with something that appears logical and shouldn't happen:

I have 3 tables - Purchase orders with amounts per vendor, invoices paid with amounts per vendor. the issue is , first table keeps vendors as vendor ID as unique key, invoices paid keeps vendors as different alpha vendor key. So I created joiner table, with vendor ID as unique key, relating to first table, vendor Alpha key relating to second table and vendor name as third column in joiner table. but when i create a matrix, with vendor name from joiner table, and invoice amount from first table and invoice amount from third table, I get same amount everywhere, it appears to be grand total. What am I missing? Thank you for any help!

[Phil_Seamark]

Hi @afedianine

Rather than create a joiner table, which sounds like a solution more for a many-to-many relationship, perhaps join your invoices table to your Purchase order table.  If your Purchase order table keeps a unique Vendor ID column then this is probably a better structure.

Or in your existing on, make sure one of the relationships is set to Both (not recommended unless you understand the problem you are trying to solve)

Does that help?

[Phil_Seamark]

[Eric_Zhang]

@afedianine

Is it possible to upload a sample pbix? It would be more helpful to understand and find out the reason.