Exclusions in Measures

[shonarugg]

Hi There,

I am trying to do a count of items by client in a measure - just a text box to get to the correct number checking against the data.

I would like a count of items in a list excluding, for example the below clients.

I know that this is incorrect, but I can't remember how to list the exclusions in the expression.

=count(distinct(if(ClientCode <> 'Client1' or 'Client2' or 'Client3', Item)))

Any suggestions?

Thank you.

[Clement15]

Hello, does this work?

count(distinct {<ClientCode -={ 'Client1' ,'Client2' , 'Client3'}>} Item)