Calculate for exact text formula changed to 'contains' text formula...

[unclejemima]

I've got a calc that works off some exact text.  In this case the text it looks for is "W2-FLSS".

I'd like to change the formula so that if it sees any instance of the word "FLSS", it will return a result...not just "W2-FLSS" what is unfortunately to exact and doesn't work right now.

Here the current calc with the exact text "W2-FLSS".  If someone would be kind enough to rewrite the calc so that it would grab results from anything with the words "FLSS".

Skid_Avail_FLSS = 
CALCULATE(
    SUM(Stok[Skid_Qty_Avail]),
    Stok[Location] = "W2-FLSS",
    VALUES(Stok[QTY-Available])
)

Thanks!

[unclejemima]

That appears to do the trick!  Thank you!  Will mark as solved.

[tackytechtom · Accepted solution]

Hi @unclejemima ,

How about using

CONTAINSSTRING ( Stok[Location], "FLSS"),

instead of 

Stok[Location] = "W2-FLSS",

Let me know if this works 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/