Forum Discussion

jch's avatar
jch
Microsoft Employee
5 years ago
Solved

Can't determine relationship between fields

I have 2 tables: 1. Table readin contains a calculated field : Actual Date = if(SEARCH("/",readin[Actual], 1, -1) > 1,DATEVALUE(readin[Actual])) 2. Table DimDate contains a date and associated ca...
Need Help
  • jch's avatar
    jch
    5 years ago

    I appreciate your help on this. The answer ended up being

     

    In a one-to-many relationship, you can only filter the relationship by table like table2, but not vice versa.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi jch ,

 

You are trying to use two or more fields from tables that are not related. You need to remove the unrelated fields from the visual and then create a relationship between the tables. Once you have done this change, you can add the fields back to the visual.

 

Refer to: 

Create and manage relationships in Power BI Desktop 

https://community.powerbi.com/t5/Desktop/Error-Can-t-determine-relationship-between-fields/m-p/908488

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.