Calculate sum of parent ID from Child table

[Anonymous]

Hello, I am creating a summary table that has unique transaction IDs from the Child table. I need to add a column to that table that takes the sum of 'table'[Wait] for the specific parent ID. 

Parent Table (What I need)

Parent_ID     Total_Wait

111                0:00:20

222                0:00:35

333                0:00:07

Child Table:

Transaction_ID       Wait

111                       0:00:10

111                       0:00:10

222                       0:00:20

222                       0:00:15

333                       0:00:07

I tried this with no luck:

Total_Queue_Wait =

   CALCULATE(

       SUM(
          'Child Table'[Wait]),

          'Child Table'[Transaction_ID] = 'Parent Call Transactions'[Parent_ID]

   )

[vanessafvg]

measure_name =
VAR transid = 'Child Table'[Transaction_ID]
RETURN
    CALCULATE (
        SUM ( 'Child Table'[Wait] ),
        FILTER ( 'Parent Call Transactions', [Parent_ID] = transid )
    )

[Anonymous · Accepted solution]

I figured this out using SUMX: 

Total_Queue_Wait =

SUMX(

FILTER(

'F_Phone Interactions',

'F_Phone Interactions'[Original_transaction_ID] = 'Parent Call Transactions'[Parent_Transaction_ID]),

'F_Phone Interactions'[Queue Wait Duration]

)

[ChrisMendoza]

@Anonymous - Take a look at the attached.

Column = 
CALCULATE(
    SUM(Child[Wait]),
    FILTER(
        Child,
        Child[TransactionID] = 'Parent'[TransactionID]
    )
)