How to find distinct number of customers who have purchased all of 3 specific items

Q&A
,
1

I am trying to find the count of all customers who have purchased all of Item 1, 2, and 3. I have tried using the AND filter, however when I use it, it gives me no data. I have also tried using calculated fields and using code to find the distinct count, but none of these approaches work. Is there any way I can find the distinct count of customers who have purchased all of items 1, 2, and 3 like shown in the table below? In this example, the result should be 2 since Customer B and D purchased all of item 1, 2, and 3.

Customer Item Purchased?
A Item 1 1
Item 2 0
Item 3 1
Item 4 0
Item 5 1
B Item 1 1
Item 2 1
Item 3 1
Item 4 1
Item 5 0
C Item 1 0
Item 2 1
Item 3 0
Item 4 1
Item 5 1
D Item 1 1
Item 2 1
Item 3 1
Item 4 0
Item 5 1
2

You can do something like this:

ifelse(countOver(ifelse({purchased}='1' AND {item}='Item 1',{customer},NULL),[{customer}],PRE_AGG)>1 AND countOver(ifelse({purchased}='1' AND {item}='Item 2',{customer},NULL),[{customer}],PRE_AGG)>1,'Purchased 1 & 2','Not Purchased')