Total Sum from child table

[jfoods301]

Hello, 

I have two tables:

Productions (Parent Table)

Checks (Child Table)

Inside the Productions table, I have a column "Total Pits", and I want to get the total sum from the Checks table under the column "Pits".  Will someone help me? 

Thanks, Lon

[dbaum]

---

@jfoods301 wrote:

the total sum from the Checks table under the column "Pits"

---

SUM(Checks[Pits])

If instead what you need for each Productions row is the sum of only that row's Checks rows, try the following:

SUM([Related Checks][Pits])

[jfoods301]

Thanks for your reply. It does work, though.

But I noticed that if add a new row in the child table, the column "Total Pits" in the parent table does not update automatically. 

[dbaum · Accepted solution]

A row's data source columns recalculate only if the row is edited--not when other rows in the same or other tables are edited. If you used a data source column for your sum, try using instead a virtual column.

[jfoods301]

Thank you!