distinct count that keeps all selections besides the WHERE condition

[#1]

Hi Experts,

I'm new to Qlik but familiar with SQL so please forgive any incorrect terms.

I'm trying to write an expression return the distinct count of the values in [Visit.Event.ID] where the field [Department] = ''Repair' and every other user selection applies also.  (i.e. Dealership, Grade, etc)

This seems to be close, but not quite. 

Count({$<Department={'Repair'}>}Visit.Event.ID)

Can anyone tell me what I'm missing?

Thanks in advance!

[swuehl · Accepted solution]

Maybe just a DISTINCT qualifier?

Count({$<Department={'Repair'}>} DISTINCT [Visit.Event.ID] )