Forum Discussion
Can't determine relationships between the fields
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.
- SamWiseOwl
Super User
If you don't care about have the users on a seperate row you could do this:
Users In Project =
ConcatenateX( UserTable, [User Column],", ")That will show them in a nice comma seperated list next to the phase.