Combining Summing and Filtering

[izov]

Hello,

Got stuck with a thing and I could us some help. It is fairly simple, but I can't get through it.

I have a table that has a list of deals that include info (on row level) like deal amount, the reseller that placed the order, and the product that wasp urchased. What I am trying to do is to create a measure that shows me the number of resellers that had total revenue larger than 0 for all products in our portfolio except for one specific product.

Any htoughts?

Thanks!
Kiril