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.
