Forum Discussion
Filter error. The expression refers to multiple columns.
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
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.