Powerpivot question

[deankavon]

Hi! can anyone tell me which dax exp. could i use for the following problem;

I work in retail and we are trying to figure out how our customers are buying. So...the data looks like this;

Offer number- inside the offer there is a product specification; if the customer buys products A, B and C together, then we know they are buying the entire solution from us.

What i need to find out is how many offers have been sold containing all 3 products together, 2 products,1 product and so on.

Any ideas?

thnx!

 

[scottsen]

I want to say we had a similiar questions a few weeks back, you might search a bit.

Also this would be a good place to start: Basket Analysis – Dax Patterns