DAX to Multiple different rows in different columns of the same table

[Anonymous]

Hi All,

I want to multiple selling price by QTY. the Selling price is in a different row to QTY. where selling price is being mentioned the QTY is zero and where the QTY has been mentioned the selling price is zero.

I have added the screen shot of my data. 

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

Expected invoice value: =
SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( Data, 'Item'[Item] ),
        "@qty", CALCULATE ( SUM ( Data[Qty] ) ),
        "@unitprice", CALCULATE ( MAX ( Data[Unit Price] ) )
    ),
    [@qty] * [@unitprice]
)