Sum onf minimum values

[vbourbeau]

Hi,

I want to take the minimum value of a price break and multiply it by the line quantiy. look the image above.

The price and quantity must be break by lines. the grand total must be 303?

here my dax formula:

CALCULATE(MIN('Price Break'[Price]))*sum(Line[Qty])

And the example: https://we.tl/t-UtpnU73gRw

[amitchandak]

Try like

total = SUMX(SUMMARIZE(Line,Line[Invoice],Line[InvoiceLine],"_min",min('Price Break'[Price])*sum('Price Break'[Price])),[_min])

[vbourbeau · Accepted solution]

Ok I find it

I need to put the dax command in a column not an measure.