Forum Discussion
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 user name, etc.)
laundries contracts shows for each laundry branch the start- end dates for the contract with the commission value for the contract
in order to connect these tables i created a UNION table by using disticst values for laundry branch id from orders table and distinct branch id values in laundries contract table.
now, in the output i want to create a table visual that shows me the following:
(orderID-laundry branch name- commission value)
when i tried to create a table i got the following error :
6 Replies
i want to use laundry_branch_id from (laundryBranch ID) table, orde id from (Query) table and commission_ percentage from (laundries contracts). all the coloumns should be not summarized
Do you get the expected result if you summarize the percentage column? One of them need to be summarized (or have a measure doing so) for that to work.
Pat
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
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
