Forum Discussion
Solved
Sum from related table
I am trying to sum values that are on other tables onto a master table, but I can't seem to get it to work. It is essentially a Sumif function, but I can't seem to get Calculate and or SUMX to wo...
Try:
AssignmentTable[Total Fee] = CALCULATE(SUM(Revenue[Fee]))
The calculate is weird and required.
Your "What is Happening" is confusing on the Assignment table -- I assume there are actually 3 rows there?
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.