sum with criteria

[Dean_Mcghee]

I have a columne with material, A column with order #, and A column with order qty.  I want to be able to look at the total qty of the material ordered for the shipment(order) and not sum every instance of the material in the data. How do you sum but only for the material and only for that one order? 

[Dean_Mcghee]

This is an example of my data.

The Source Target is the order amount of the material in column A.  For the first one, they orderd 72.  Thats what I need the measure to display.  Right now I have tried sum both alone and with filters, lookupvalue to create a new column.

Nothing I do works.  It either wants to sum all the material in the whole column, Or just count How many times that material shows up in the column.  I didn't think just pulling order qty would be so hard.

[amitchandak]

@Dean_Mcghee , Not sure why you need a new column

new column

total = sum(Table[Source Target Qty])

total of material = sumx(filter(Table, Table[Material] = earlier([Material]) ) , Table[Source Target Qty])

measure will be like

new column

total = calculate(sum(Table[Source Target Qty]), allselected()) //or use all in place of allselected

total of material = sumx(filter(allselected(Table), Table[Material] = max([Material]) ) , Table[Source Target Qty])

row level total = sum(Table[Source Target Qty]) 

[FreemanZ]

it would be good if you could provide some sample data and your expected result.