Calculate sum of column 1 where column 2 = value A or value B but not value C or value D

[Anonymous]

I am trying to write DAX to calculate the sum of column Quantity where column Age equals value A or value B but not where it equals value C or value D. 

I know how to calculate the sum for one value, but I can't figure out to calculate based on two values. 

For one condition, I have: 

NUMERATOR2 = CALCULATE(SUM(Part4[Quantity]), Part4[Age] = "DSP 0-63")

My Table looks as so:

 Table: Part 4

Quantity	Age
5	DSP 0-63
5	DSP 0-63
5	DSP 64-126
5	DSP 64-126
5	DSP 127-200
5	DSP 127-200
5	DSP +200
5	DSP +200

I need to calculate the sum of Quantity where Age = DSP 0-63 or DSP 64-126. 

Thanks! 

[ChrisMendoza · Accepted solution]

@Anonymous -

This seems to work:

Measure =
CALCULATE (
    SUM ( 'Part 4'[Quantity] ),
    FILTER (
        'Part 4',
        'Part 4'[Age] = "DSP 0-63"
            || 'Part 4'[Age] = "DSP 64-126"
    )
)

[Anonymous]

Thanks! This only gives me the total for DSP 0-63. I need the total for DSP 0-63 + DSP 64-126

[ChrisMendoza]

@Anonymous -

I do not understand what you mean.

[Anonymous]

Never mind.  I did a hard refresh, and everything works. Thank you! 

Marie