Forum Discussion
Sum from related table
Try:
AssignmentTable[Total Fee] = CALCULATE(SUM(Revenue[Fee]))
The calculate is weird and required.
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
Can you show a picture of your model relationships -- this should have worked fine...
Structure:
Relationships: The tables are connected via an Assignment Key field.
Formula: HHG = CALCULATE(SUM('Assignment Schedule Split'[Revenue (USD)])).
- The fields on the left of HHG are from the Assignment table.
- The formula is on the assignments table
What about a SUMIFS formula? if you want to also exclude a category from the sumif formula?
