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

     

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous ,

 

Since there is no direct relationship between Tables 1 and 3, the visual does not know how to combine them.

When table 2 is added to the visual, both tables are filtered and displayed via the common table 2.

 

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

  • jaryszek's avatar
    jaryszek
    Super User
    9 months ago

    Ok what is a solution for it?

    • mwegener's avatar
      mwegener
      Most Valuable Professional
      8 months ago

      Hi jaryszek 
      I would add a measure (e.g., count) based on Table 2 of the visualization.

       

      • jaryszek's avatar
        jaryszek
        Super User
        8 months ago

        Thank you