Error in filter formula

[Giada_Togliatti]

Hi,

I have sample data of a superstore and I want to filter orders which have quantity>5, I tried to do a formula like this

Measure = FILTER(Orders; Orders[Quantity]>5)

but I have this error: 

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

What is the meaning and how can I reach the result?

Thank you

[AilleryO]

Hi,

Can you tell us more about your expectation as a final result.

A list of order, counting them, make a sum of their total amount ?

For a list use a CALCULATETABLE function, or a CALCULATE if you want a single result (COUNT, SUM...)

Hope it helps

[amitchandak · Accepted solution]

@Giada_Togliatti , Create a measure like this. Use it in card visual or with order number/ID on other visuals

calculate(countrows(Orders), FILTER(Orders; Orders[Quantity]>5))

Filter return table not a value