Forum Discussion

catleen's avatar
catleen
Frequent Visitor
3 years ago
Solved

Ambiguity between tables error when adding translation layer

Hi!

I am trying to add a translation layer on my data model and the model is similar to the image below. But I am getting an ambiguity between tables error when trying to create the relationship to the Language table. I understand the error and why it is happening but I am wondering is there any way around it. The only way I could think of is to add the USERELATIONSHIP() to the measures I am using. But as there are a lot of measures and dimension table in the real model I was thinking is there another way. Maybe the model needs to be different? 

 

Any ideas are welcome!

Thanks!