Multiple columns error

[BishwaR]

BlackProducts = FILTER(Products, Products[Color] = “Black”)

It returns an error  "the expression refers to multiple columns. multiple columns cannot be converted to a scalar value"

Without creating a table how to use the above expression into a Dax to create a measure 

it works perfect if I use the create new table option but I want to create a measure 

thanks

[amitchandak · Accepted solution]

@BishwaR , Filter return a table so measure will error for that.

You can have measure like this

BlackProducts = calculate(countrows(Products),FILTER(Products, Products[Color] = “Black”))

or

BlackProducts = calculate(countrows(Table),FILTER(Products, Products[Color] = “Black”))

[BishwaR]

Thanks @amitchandak  Now how can I add a condition like if it is " Black" then " N/A" in the same measure

[amitchandak]

@BishwaR , 

if(isblank(calculate(countrows(Table),FILTER(Products, Products[Color] = “Black”))), "No data", "NA")

something like above, you can swap then and else results