Summing up Duplicate Rows

[Anonymous]

Hello Community, 

I have merged two different tables - one containing returns, and one containing shipments.   The overall output of this table is what I need, and I am aware of the duplication that is occuring.  

Having said that, what I am simply trying to achieve is for the total of the "replacement quantity" column to give me the correct results.   Which, in my example below, would be 1,200.     The shipped quantity column is summing up to 1,200 which is correct.  

And I am fine with having the repeated rows as we know why this is occuring, but all we need to do is to get the sum of that replacement quantity column to only count one instance per RMA Line, so the total would end up being 1,200.   Currently that column is just coming from the column in the dataset, it is not a calculated column or measure.    I have tried creating various measures but they give me wrong values.   I am fine with creating either a new column or new measure that gives me the same result as the current column shown below (with the repeated values), as long as it gives me the correct "replacement quantity" total of 1,200.    How to accomplish?

[danextian · Accepted solution]

Hi @Anonymous ,

Assuming that the line should be by RMA Number and the RMA Quantity only has the same value for each line:

=
SUMX (
    SUMMARIZE (
        'Table',
        'Table'[RMA Number],
        'Table'[RMA Line],
        'Table'[Replacement Qty]
    ),
    [Replacement Qty]
)