Matrix Grand Total Incorrect - much larger

[Kelly-DS]

I would really appreciate some help with my matrix grand totals. As you can see these are wrong:

Product ID 6904 we sell in singles (ID 11977) and cases of 24 (ID 22656)

The total units sold are correct however the grand total is incorrect.

Looking at period 2019.1 I can see that it is taking the singles 35 + cases 2 = 37 * 25 being the associated quantity required (single 1 + case 24)

The values come from this measure that gets data from 2 tables:

Total Qty = SUM('Order and Lines (excluding unpaid) - DATA'[Order Qty]) * SUM('ProdVer Inventory Links - CURRENT'[QuantityRequired])

Thanks in advance

Kelly

[PaulDBrown · Accepted solution]

@Kelly-DS 

Based on the measure you already have, try:

Totals = SUMX(ProductId Table, [Total Qty])

[Kelly-DS]

That's great thank you! Worked 🙂