Relationship Error DIM to FACT

[strongman_pbix]

Good afternoon - I am building out a report that assists the user with Supplier Payment Installments (FACT) data that uses some relevant info from Supplier (DIM) and Supplier Invoice (DIM) - These joins work in the relevant Snowflake data table using the same logic (joining on relevant keys) but in my Power BI semantic model, they don't talk to eachother.

Supplier Invoice Lines (FACT) is set up the same way, and i've checked the data types on the joining keys, all match. Below is some more information, please let me know if I can provide more info.

Table 1	Relationship Type	Relationship On:	Table 2	Status	Notes
Supplier (DIM)	1 to *	Supplier Key	Supplier Invoice Lines (FACT	Works as expected
Supplier (DIM)	1 to *	Supplier Key	Supplier Payment Installments (FACT)	Does not work	Blank table
Supplier Invoice (DIM)	1 to *	Supplier Invoice Key	Supplier Payment Installments (FACT)	Does not work	Shows suppliers and payment installment amounts but the amounts don't match what is in the table in our warehouse
Supplier Invoice (DIM)	1 to *	Supplier Invoice Key	Supplier Invoice Lines (FACT)	Works as expected	When I add Supplier Payment installments to this it doesn't BREAK but data doesn't match to the warehouse table

[v-yiruan-msft]

Hi @strongman_pbix ,

It seems like the data in the visual didn't display the expected result base on the current relationships between the fact tables and dimension tables. Could you please provide the following info for the further troubleshooting?

• Provide some sample data(exclude the sensitive data) in these tables, you can refer the following link to share the required info:

  How to provide sample data in the Power BI Forum

• The visual fields settings
• If the visual involves any measure, please provide the related formula.

Best Regards