Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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,
Hi @Anonymous,
Could you please mark the proper answers as solutions?
Best Regards,
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,
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |