Loop through filtered items to qulify a count

I have data similar to the table below and would like to do the following   User selects Brand A,B,D from a filter I want to display the distinct count of ID's per Brand that is qualified based on...