Forum Discussion
Filter Measure Error - The expression refers to multiple columns....
I have a table of all our tickets and I want to display a number, that number being all the tickets out of SLA.
SLA = Filter(AllTickets, AllTickets[SLA Resolve By Deadline] < TODAY())
but I get
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
Measures take a collection of rows, and return a single value (a scalar value). Your current measure is... not doing that, the filter will take a set of rows and return a smaller set of rows.
By simply wrapping it in some aggregate function (in this case COUNTROWS) you will be dancin' :)
SLA := COUNTROWS(Filter(AllTickets, AllTickets[SLA Resolve By Deadline] < TODAY()))
1 Reply
Measures take a collection of rows, and return a single value (a scalar value). Your current measure is... not doing that, the filter will take a set of rows and return a smaller set of rows.
By simply wrapping it in some aggregate function (in this case COUNTROWS) you will be dancin' :)
SLA := COUNTROWS(Filter(AllTickets, AllTickets[SLA Resolve By Deadline] < TODAY()))