Need help to Calculate SUM for multiple filters conditions

[ahipon]

Hello,

Below expression is working and sums qty for "Demand" and "Stock" but I need to sum for "Demand","Stock", and "Supply".

Please help to rewrite in order to filter the Rollup Field for all three conditions.  Thank you.

Demand+Stock = calculate( SUM('Table1'[Rec./reqd quantity]), filter(Table1,Table1[Rollup]="Demand"||Table1[Rollup]="Stock"))

[tamerj1 · Accepted solution]

Hi @ahipon 

you can use

Demand+Stock =
CALCULATE (
    SUM ( 'Table1'[Rec./reqd quantity] ),
    Table1[Rollup] IN { "Demand", "Stock", "Supply" }
)

[ahipon]

Thanks!  Most appreciated!