One to Many relationship not working

[GK600]

Hi,

I am stuck and hope someone can help. I have below one to many relationship between 2 tables.

I created this 'Country' table with distinct values to link with multiple tables to take this as a base for any visualizations. It is working fine for all except below where picking country from the table where DAX calculation exist is working. But picking country from related table is somehow changing the numbers. 

It is difficult to explain the exact calculation in the fact table as there is lot of cross referencing and I managed to it make it work with help of various online resources rather understanding perfectly. I can't share the file as it's got PII. I am hoping someone may be able to give a pointer as to what may cause such a situation because my understanding so far has been that selecting a field from dim table should work as long as its working in the fact table on its own.

Look forward to hear from you.

Thanks,

Gaurav

[lbendlin · Accepted solution]

You may want to read this article, it describes the mechanics behind using fields from different sides of a join.

From SQL to DAX: Joining Tables - SQLBI