Filter Measure Error - The expression refers to multiple columns....

[jehall]

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.

[Anonymous · Accepted solution]

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()))