Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |