data model connection error

[lawada]

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 :

[mahoneypat]

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

[lawada]

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

[Pragati11]

Hi @lawada ,

Out of your 3 tables, from which tables are you moving the columns to this visual?

Is there any summarisation on the column when moving to visual?

Thanks,

Pragati

[lawada]

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

[mahoneypat]

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

[lawada]

summarizing the percentage column will result in different values which wont be correct . is there a way to solve this without having to summrize the percentage coloumn