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 =
And the same for total units sold
Total unit sales = SUM(PQSales[Invoiced Quantity])
thank you for your support.