Hi everybody! I have the following problem:

I have the Store dimension which has members store1, store2, store3... storeN

I have the measure QtyDocuments that count the people who bought in each store

Ex.
StoreQtyDocuments
store14
store22
store31

Supose that the person who bought in store3 (John) also bought in store2. QtyDocuments use a distinct count so the total in the example is 6.

Now, my problem is that I need the result of QtyDocuments of people that bought in store1 and store2, but I need to exclude those who bouth in store 3. As "John" bought in store3 I need to exlude him from all the stores where he appeares (in this case store2) So the total of QtyDocuments should be 5.

Hope you can help me!
Thanks,
Paul