I have a group of invoices with multiple line items. the shipping cost is at invoice level and is repeaded on each line. I want to find the total shipping cost for a group of in voices but am findind duplicates. I need t write a measure so that the following table would calculte total shippingcost as $125.2 InvoiceNoItemCodeShippingCostABC780A25.2ABC800B25.2ADE9000C100 I am only coming up woth either 100 (the max shipping on all invoices) OR 150.4, the sum of all shippingcosts. the best measure I have so far is: Total shipping =VAR InvoiceShipping = MAXX(ALLEXCEPT('MyTable','MyTable'[Invoiceno]),'MyTable',[ShippingCost])RETURNSUMX(VALUES('MyTable'[Invoiceno]),CALCULATE(SUMX(InvoiceShipping)))

Hi ndev ,I was able to reproduce this issue end to end. The duplication happens because the shipping cost is stored at the line item level, so using a normal SUM( ) ends up counting the same shipping value multiple times for a single invoice. To fix this, the calculation needs to first evaluate the shipping cost at the invoice level and then sum those invoice level values, which prevents the shipping cost from being double counted.I used the below measure: Total Shipping = SUMX( VALUES( 'Shipping'[InvoiceNo] ), CALCULATE( MAX( 'Shipping'[ShippingCost] ) ) ) This works because VALUES(InvoiceNo) returns a distinct list of invoices, and MAX(ShippingCost) retrieves the single shipping value per invoice before summing. This eliminates duplicate counting while still respecting report filters.Please find the below attached .pbix file for your reference. Thank you.

eliminate duplicate Shipping costs | Microsoft Fabric Community

Forum Discussion

Related content

Eliminate duplicate records while keeping the most recent record.

Eliminating duplicates rows in table

Duplicate ranking

Grouping Eliminating Duplicates

Eliminating duplicate parameter entries in PBI Report Builder