Forum Discussion

cdfisher89's avatar
cdfisher89
Frequent Visitor
9 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Try:

    AssignmentTable[Total Fee] = CALCULATE(SUM(Revenue[Fee]))

     

    The calculate is weird and required.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Can you show a picture of your model relationships -- this should have worked fine...

cdfisher89's avatar
cdfisher89
Frequent Visitor
9 years ago

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

 

  • cdfisher89's avatar
    cdfisher89
    Frequent Visitor
    9 years ago

    I fixed it.  You were right on the formula.  The "key" field was slightly different, which caused all the issues. 

     

    Thanks!