Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to use SUMX across multiple tables

I am trying to understand how to colelct the effort data for a project. I have two tables: Tasks and Sub-Tasks. Each sub-task is linked to a Task with the Task Key. We have effort for tasks as well a...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    Hi Anonymous 

    please try this measure

    total = MIN(TableA[Effort])+ CALCULATE(SUM(TableB[Effort]),FILTER(TableB,TableB[TaskKey]=MIN(TableA[TaskKey])))

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

mangaus1111's avatar
mangaus1111
Icon for Solution Sage rankSolution Sage
4 years ago

Hi Anonymous ,

you need a relationship between Task and Subtask tables and then you create this meaure

Measure = 
SUM('Task'[Effort Task]) + SUM('Subtask'[Effort SubTask])

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

mangaus1111  I tried this, it gives the same value, sum of all effort for every row. Not sure if I am missing anything.