Forum Discussion

jadewind's avatar
jadewind
Advocate I
9 years ago
Solved

Error: Can't determine relationships between the fields

  I have been trying to display a table with two fields: Person and Items by using above model. However the visual cannot displayed due to subject error. How can I make it work?
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi jadewind

     

    Is it not possible to combine the Age Cateogry, Age and P tables together using the Query Editor?

    This will then allow you to view the data the way you want?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

jadewind, have you found a solution without using join?

jadewind's avatar
jadewind
Advocate I
8 years ago

Hi caaarlos, 

 

I haven't. I guess the reasion I couldn't do it using my original model was because the relationships were not one to one. I have since found in some cases where the relationships were one to one I could achieve it. Maybe when the relationship is one to many PBI doesn't know which one I want to pick so it just doesn't do it. 

 

I have found myself using "merge" very often now...

 

Hope this helps. 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi jadewind,

     

    My model relationship is also many to many. Anonymous suggestion worked, but has some drawbacks. Like I said on his answer I cant use don't summarize on all columns. I agree with you, merging tables, right now, is the best solution.