Forum Discussion

GK600's avatar
GK600
Icon for Helper II rankHelper II
4 years ago
Solved

One to Many relationship not working

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