Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
Solved! Go to Solution.
You could use just that column instead of the whole table then.
WorkerName = FILTER ( VALUES ( Worker[WorkerName] ), Worker[WorkerName] = "Once Off" )
FILTER returns a table whereas Power BI is expecting a single scalar value. What are you trying to return instead of a table?
Just a field name Worker[WorkerName] = "Once Off"
You could use just that column instead of the whole table then.
WorkerName = FILTER ( VALUES ( Worker[WorkerName] ), Worker[WorkerName] = "Once Off" )
Great bro. It's working perfectly.
Thanks a alot.
Check out the May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
71 | |
70 | |
52 | |
48 |
User | Count |
---|---|
45 | |
38 | |
33 | |
31 | |
28 |