Basket Analysis Help

[eliwaite]

I am doing a basket analysis in Power Pivot, and I am almost there, but am hitting one last snag which I cannot figure out. The question I am trying to answer is how many customers purchased a specific product (with net revenue greater than zero), along with another product (with net revenue greater than zero). The data set I have has both returns and sales. The formula I have built is:

Orders with Both Products:=CALCULATE(DISTINCTCOUNT(Data[Customer Key]),CALCULATETABLE(SUMMARIZE(Data,Data[Customer Key]),ALL('Product Category'),USERELATIONSHIP(Data[Product Key],'Filter Product Category'[Filter Product Key]),Data[Net Revenue]>0))

This formula provides me with how many people bought a product (regardless of net revenue) and how many bought another product (with net revenue greater than zero). Thus, my question is how should I modify my formula so both products have a net revenue greater than zero?

Thanks for your help.

 

[Matt Allington]

have you looked at this? Basket Analysis – DAX Patterns