Using SUMMARIZECOLUMNS or SUMMARIZE as a Measure

[Anonymous]

Hey All

I have a table with all order lines. This means I have multiple rows per order. Each row is an Articleposition. I would like to sum up all articles per order.

Mey expected Result:

orderID	Price	TotalOrderPrice
1	10	60
1	20	60
1	30	60
2	10	50
2	10	50
2	10	50
2	10	50
2	10	50

I have managed to get to that result by using below dax formula:

TotalOrder = SUMMARIZECOLUMNS('Lian CH$Sales Invoice Line'[OrderNo],"Total", sum('Lian CH$Sales Invoice Line'[AmoutNoVat]))

However, this is only working when creating a new table. This does not work for a measure.

Is there any way to use it as a measure.

Thank you in Advance

[AlexisOlson]

I don't think you need either for this.

Try this:

TotalOrderPrice =
CALCULATE (
    SUM ( Sales[Price] ),
    ALLEXCEPT ( Sales, Sales[orderID] ),
    ALLSELECTED ()
)

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

TotalOrderPrice = sumx(filter(allselected('Lian CH$Sales Invoice Line'), 'Lian CH$Sales Invoice Line'[OrderNo] = max('Lian CH$Sales Invoice Line'[OrderNo] )),'Lian CH$Sales Invoice Line'[AmoutNoVat])