Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    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.

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

     

    Best Regards,

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    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.

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

     

    Best Regards,

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous,

     

    Could you please mark the proper answers as solutions?

     

     

    Best Regards,