Forum Discussion

Giada_Togliatti's avatar
Giada_Togliatti
Post Patron
5 years ago
Solved

Error in filter formula

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
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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

  • AilleryO's avatar
    AilleryO
    Memorable Member
    5 years ago

    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