Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!