Issues with measure totals

Hello Team,

I have been trying to put together a report that shows total tonnes sold.

The issue is that the measure totals do not add up in the bottom of my tables.

I have looked at a solution that has been posted but im a little confused!

Is it not possible to use measures dynamically in this way?

Unit weight is a simple sum formula

Unit weight =
SUM(PQParts[Unit Weight])

And the same for total units sold

Total unit sales = SUM(PQSales[Invoiced Quantity])

thank you for your support.

have you tried sumx? the 2308 on the left table doesn’t have context.

1 Like

Sorry guys I have solved it with an iteration function SumX :wink: