Forum Discussion
lawada
5 years agoHelper III
data model connection error
i have three tables connected to each other as shown in the image below: to explain the model: (Query) table shows the order id with the laundry branch name and other orders details (like us...
mahoneypat
5 years agoMicrosoft Employee
Those bi-directional relationships are likely causing ambiguity in your model (i.e., >1 ways to get between tables). Hard to tell w/o seeing the whole model. You should avoid using those and learn about TREATAS, CROSSFILTER, etc. to pass filters differently.
Pat
- lawada5 years agoHelper III
even when using single filtering direction im getting the same error , and other tables in the model are calender tables which won't affect in the issue im having now