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.
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