PowerPivot/Dax CALCULATE question

Hello all,

I am somewhat familiar with the DAX functions and expressions in PowerPivot. But I have ran into an issue I can't seem to solve. I would like to sum up the values in Column 2 (number values) only when a value in Column 3 (text values) contains a specific word.

I assume I need to combine the function CALCULATE with some type of filter that would allow me to state that. Would the best approach be combining the CALCULATE function with CONTAINS function? Although I seem to be having some problems with that. Or should it be something else?

-Thank you

Bumping in hopes someone has a solution.

Bumping for visibility

I was able to figure it out. For anyone else who has this problem, or is just generally interested, here is the formula that worked for me:

CALCULATE(SUM(Sheet1[column1]),SEARCH( "text", Sheet1[column2], 1, 0 ) > 0).