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 t...
projectID is from project table ID column
contractors = DISTINCTCONT([CONTRACTORS_ID])
- danextian
Super User
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?
- danextian
Does the fact table have contractor id? What columns did you use to connector contractor and fact?
