Forum Discussion
catleen
3 years agoFrequent Visitor
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!