Forum Discussion
Sum from related table
Try:
AssignmentTable[Total Fee] = CALCULATE(SUM(Revenue[Fee]))
The calculate is weird and required.
Sorry. It isn't summing up at the relevant rows. It is just giving me a total for all assignments. I would like the total fees and hours for each assignment based on the other tables.
You can disregard the bottom half. I am just trying to create the Fee and Hours columns in the Assignment Table
Try:
AssignmentTable[Total Fee] = CALCULATE(SUM(Revenue[Fee]))
The calculate is weird and required.
Didn't work. It seems to just calculate the total rather than for each assignment. I tried both as a measure and as a column.
I feel that this one is asking the same question (I have a one to many relationship), but i havent been able to get it to work http://community.powerbi.com/t5/Desktop/Create-a-Calculated-Column-from-Different-Tables/m-p/60773#M24944http://community.powerbi.com/t5/Desktop/Create-a-Calculated-Column-from-Different-Tables/m-p/60773#M24944
What about a SUMIFS formula? if you want to also exclude a category from the sumif formula?
