Sum with multiple wildcards (partial matching on text)

[Anonymous]

I am trying to sum all product names including "test" and "combo". Below formula only works with "test". I need a way to add more criteria.

= CALCULATE(SUM(Salg[Net Invoiced Quantity in Base UOM]),
                SEARCH("test", Salg[Product Name],,0))

Product Name	Net Invoiced Quantity in Base UOM
aaaa test	5
bbbbb	10
bu test bhsy	20
combo	25

[amitchandak · Accepted solution]

@Anonymous , Try like

CALCULATE(SUM(Salg[Net Invoiced Quantity in Base UOM]),filter(Salg,SEARCH("test", Salg[Product Name],,0) >0 || SEARCH("combo", Salg[Product Name],,0) >0 ))