Power BI measure with multiple criteria

[jonclay]

Hello

I'm trying to create a measure whereby a distinct count of serialnumber is made when the name field on the employment entity is either one, two or three.

I've written the code as below, but I'm getting the error "The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column."

Count = CALCULATE(DISTINCTCOUNT(employment[serialnumber]),employment[name] = "one","two","three")

Do you know what I'm doing wrong please?

Many thanks
Jon

[jonclay]

@amitchandak Amazing!!! Thank you SO much 🙂 

[Anonymous]

this should work

Count = CALCULATE(
DISTINCTCOUNT(employment[serialnumber]),
employment[name] IN {"one","two","three"}
)

[amitchandak · Accepted solution]

@jonclay , Try in

Count = CALCULATE(DISTINCTCOUNT(employment[serialnumber]),employment[name] in{ "one","two","three" }  )