Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
LucasFiorini
New Member

Check if value is in a List

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!

1 ACCEPTED SOLUTION
daXtreme
Solution Sage
Solution Sage

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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
Solution Sage
Solution Sage

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.