Sum Invoice Value if contains a specific row

[Anonymous]

Hi everyone!

I have 3 important columns: Document_No (the invoices), Description (article/SKU) and Value (the QTY)

How can I sum Value of every invoices that contains a specific row/article:

Thank you!

[tamerj1 · Accepted solution]

Hi @Anonymous 
Please try

NewMeasure =
SUMX (
    VALUES ( 'Table'[Document_No] ),
    CALCULATE (
        IF (
            { "3% Discount Card" } IN VALUES ( Table[Description] ),
            SUM ( Table[Value] )
        )
    )
)

[Anonymous]

Yes, it works! 

Thank you!

[wdx223_Daniel]

New Measure=IF(CONTAINSROW(VALUES(Table[Description],"3% Discount Card"),SUM(Table[Value]))

[Anonymous]

Thank you, @wdx223_Daniel but the result of this measure is the total of value. The if condition works like: if in one month there is "3% Discout Card" then sum of all Value, if not, blank.

I need to sum only the Document_NO that has "3% Discount Card".