Measurements to find Boolean Counts for Nots or false

[Anonymous]

 Ive created this report which works perfectly fine. Each Item showing distinct customers interested in that Item. I now want to see which customers are not interested. Im wondering what the measurement for that looks like on dax or any other way I can get that.

[amitchandak]

@Anonymous ,

Assume Item is in a separate dimension 

customers = distinct(Table[customer ID])

Try meausre like

not interested = sumx(Values(Table[customer ID]), if(isblank([customers]) , 1, blank())

[Anonymous]

That was a good suggestions amit, the issue is that I wouldnt have any blanks in my database. so it shows up empty . I what i essentially want to  show is  the same customers who are buying for the other items to show up for the customers that are not buying.. haha hope this doesnt sound too confusing .. but every customer has bought an item on this list and I want to swap them around using the same total number of customers buying