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" )
4 Replies
FILTER returns a table whereas Power BI is expecting a single scalar value. What are you trying to return instead of a table?
You could use just that column instead of the whole table then.
WorkerName = FILTER ( VALUES ( Worker[WorkerName] ), Worker[WorkerName] = "Once Off" )