using IN clause to filter from a list

[Anonymous]

Below is my query to display Projectnames form Dimproject table

EVALUATE (

Summarize(
ADDCOLUMNS
(
FILTER ('DimProject', [ProjectName] <> BLANK ()),
"ord",IF(search("All",[ProjectName],1,1)<>1,"-1",[ProjectName])
),
[ProjectName],[Ord])
)
ORDER BY [ord]

Now I only want to display projectnames which are in a list (say list = ("a","b","c")). How do I do that in the above query?

I tried FILTER ('DimProject', [ProjectName] IN {"a","b","c"}), but it gives syntaz error

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

What's the error message exactly?  Maybe it is raised by other parts of the formula. You can use it that way. Please refer to the demo below.

Best Regards,