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?

GilbertQ's avatar
GilbertQ
Super User
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?

jadewind's avatar
jadewind
Advocate I
9 years ago

Yes I was able to join tables to work around the problem. But just wondering how I can do it without joining tables....

  • 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.