Forum Discussion
Solved
Table relationship ambiguity
Hello Everyone, I am facing an issue with the tables relationships. I have below existing tables structure in my data model Onwer, Location, Status, Scope, Assessment Phase, Planning Phase, Migrat...
Hi v-amarsh ,
What is happening is that the cross filtering between tables is detecting that the relationship you want to use already exists but trough some intermidiate tables (not a direct connection).
In this case depending on what you need to calculate you need to make use of the existing relations to make your calculations, using summarize or similar to create measures and get expected results, other option is to make use of USERELATIONSHIP, this will activate the inactive relationship when you want to calculate values between the two tables.
https://docs.microsoft.com/en-us/dax/userelationship-function-dax
