Forum Discussion
Solved
Can't determine relationships between the fields
Good morning, I am struggling with this error message. I have a simple three table model. I have all three tables connected via a field called projectid. A project from the project table can have 4...
The issue is how the filtering occurs.
Project filters Phase down to the matching project,
Project can also filter User down.
This means you could display Project, Phase and an aggregate of User.
However the User table has no information about which Phase each belongs to so it will count all of them.
Effectively you have two different granularities Phase and User. PBI doesn't know how to match them up.
How do you match them up in SQL? A cross join?
What output are you looking to achieve?
I don't necessarily want a measure. What you're saying makes sense regarding it not being able to determine which phase the user belongs to.