PowerPivot DAX for SEARCH across two text values

[benoj2005]

Hi

Could someone help me with whether it's possible to do filter by one column using contains two text strings.

I've tried:
1) CALCULATE(SUM(columnname,SEARCH(OR("textstring1","textstring2"),columnname,1,0)>0)
2) CALCULATE(SUM(columnname,SEARCH({"textstring1","textstring2"},columnname,1,0)>0)

Thanks

[romperstomper]

Try something like:

 CALCULATE(SUM(columnname),FILTER(tablename,(SEARCH("textstring1",columnname,1,0)>0) || (SEARCH("textstring2",columnname,1,0)>0)))

[benoj2005]

thanks romperstomer

[benoj2005]

Just in case anyone else reads this, this was the correct syntax

=CALCULATE(SUM(columnname),(SEARCH("textstring1",columnname,1,0)>0) || (SEARCH("textstring2",columnname,1,0)>0))