count and wildcard

[stekol61]

I have a table in Sense as  below.

How can I count  'Closed' and 'Cleared' in 'Org_status'  (the result should be '3')?

[sunny_talwar · Accepted solution]

Try this

Count({<[Org Status] = {'Closed', 'Cleared'}>} DISTINCT [Ticket ID])