Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Error: Can't determine relationship between fields

Hi   I'm working with test data (limited load rows). With this test date, in a table, I'm getting the error: "Can't determine relationship between fields" when I try to view fields from two tables...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    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