Unable to create dim fact relationship with one dim and 2 facts table

[ashmitp869]

Hi,

I have one dim table employee (coming from server1) and two fact table i.e DSR (coming from server2) and Qualifications.(coming from server1)

I am able to get the Employee Code from Employye and Qualifications table but when trying to fetch employee code from DSR giving error Can't determine relationship?

[Ashish_Mathur]

Very confused.  What exactly are you trying to do?  Show the problem clearly.

[v-yiruan-msft]

Hi @ashmitp869 ,

In order to get a better understanding on your requirement and give you a suitable solution, could you please provide the following info?

• How did you fetch employee code from DSR? By creating a calculated column or measure?
• Could you please provide the screenshot with the error message(exclude sensitive data)?
• Is the date type of [Employee Code] in table 'DSR' same with the one of 'Employees'[Employee Code] ?
• What's your expected result?

Best Regards