Forum Discussion
Power BI relationship not working
An active relationship is there but still not getting the correct no's in report.
projects are connected to projectcontractors - one to many
projectcontractors are connected to contractors - many to one
7 Replies
- danextian
Super User
Where are the colums in your visual from?
projectID is from project table ID column
contractors = DISTINCTCONT([CONTRACTORS_ID])
- danextian
But where is contactors id from? It appears to me that you're aggregating the column from the dimension table. The filter from project will not flow to that table based on the screenshot of the relationship you posted ( which I can no longer find) thus you're seeing the same value for all rows.
Okay I got your point.
But how to calculate the contractors for each projectId?
