Searching column for values < 2000

Hi Anonymous ,

I test the data your provided ,run successful(see the below).

Cannot convert value '' of type Text to type Number: It might be because one of the rows contain blank value or non numberic value. In query editor, try filtering each column for a non numeric value.  

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

https://www.sqlgene.com/2019/04/30/dax-error-the-expression-refers-to-multiple-columns-multiple-columns-cannot-be-converted-to-a-scalar-value/ 

Wish it is helpful for you!

Best Regards

Lucien