Filter error. The expression refers to multiple columns.

[Anonymous]

The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

[AlexisOlson]

FILTER returns a table whereas Power BI is expecting a single scalar value. What are you trying to return instead of a table?

[Anonymous]

Just a field name Worker[WorkerName] = "Once Off"

[AlexisOlson · Accepted solution]

You could use just that column instead of the whole table then.

WorkerName = FILTER ( VALUES ( Worker[WorkerName] ), Worker[WorkerName] = "Once Off" )

[Anonymous]

Great bro. It's working perfectly.
Thanks a alot.