Forum Discussion
Error: Can't determine relationship between fields
Hi,
According to your description, i create three tables to test:
When i use 'product'[OrderDate] to filter 'Salesperson'[Salesperson], it shows the same error with you:
This is because the [OrderDate] doesnot has any relationship with [Salesperson] such as one-to-one or one-to-many.
They can just both filtered by 'Date'[Date].
Best Regards,
Giotto Zhi
hi,
it is because your relation as you tested by your self. It's hard to say exactly without seeing the tabel data.
My opinion is not all of your data is linked on the many side to one.
Example:
you have 10 rows in table 1 in one column is a id wich you can realate to the next table 2. In table2 you have also 10 row but only two of the rows match with 4 rows in table 1 now you have a one to many relation where 6 fields not linked to another table.
With three tables it will get more complex if you want to filter from table1 to table3
PS- It is not recommended to cross filter direction to both as it can have performance impact
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!