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,
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
Two years later, I have a workaround. You can make the table visual work by putting an aggregation like count from one of the columns onto the table visual. And then hide that ugly column by resizing it. Using the same dataset at Giotto Zhi, I blogged about it here: