cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rajavarman Frequent Visitor
Frequent Visitor

using IN clause to filter from a list

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: using IN clause to filter from a list

Hi @Rajavarman,

 

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.

using-IN-clause-to-filter-from-a-list

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: using IN clause to filter from a list

Hi @Rajavarman,

 

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.

using-IN-clause-to-filter-from-a-list

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: using IN clause to filter from a list

Hi @Rajavarman,

 

Could you please mark the proper answers as solutions?

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.