PowerPivot not returning correct data

The issue is likely due to how the relationship between your tables is set up in PowerPivot. If the Troy Ounces table is related to Invoice # as a one-to-many relationship, but the data model treats it as many-to-many or the aggregation is set incorrectly, the total can repeat across invoices.

Steps to fix:

Check that the relationship between the two tables uses Invoice # as the key and is one-to-many (Invoices → Troy Ounces).

Ensure the measure for Troy Ounces uses a proper SUMX or CALCULATE function referencing the related table, not just a raw SUM.

Verify your PivotTable fields are correctly using the related table context to avoid repeated totals.

If you adjust the relationship and aggregation, each Invoice # should show its correct Troy Ounce value.