Ambiguity between tables error when adding translation layer

[catleen]

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!

[lbendlin · Accepted solution]

Building Multi-language Reports for Power BI in 2023 | Microsoft Power BI Blog | Microsoft Power BI