Expression with WHERE and OR clause

[#1]

I am trying to create a chart with an expression where it does a count on OwnerID with a Where and OR clause.

For example, i want to do a count where the [Working Status] = 'Employee' or 'Consultant'.  If I do not use the WHERE clause then the chart returns all values for Working Status (i.e. Consultant, Employee, Intern, Client, etc...)

I tried using the following line of code, but it displays Consultant only.

=count ({<[Working Status] = {'Employee'},[Working Status] = {'Consultant'}>} Distinct OwnerID)

[Gysbert_Wassenaar · Accepted solution]

Try: =count ({<[Working Status] = {'Employee','Consultant'}>} Distinct OwnerID)