Check if value is in a List

[LucasFiorini]

Hello everybody!

How can I find out if one of the selected values is a string?
What I tried out:

VAR SelectedKpi = SELECTEDVALUE(KPIs[Value])
return
IF(SelectedKpi IN {"SOE"},SUM(...),BLANK())

It works, but I select multiple values, it will only work for one at a time. 
I would like to be able to check if the string is into that variable.

Thanks!

[v-binbinyu-msft]

Hi @LucasFiorini ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_ Binbin Yu

[daXtreme · Accepted solution]

You can put many values inside {...}, like {"A", "B", "C"}.