Forum Discussion

WillT's avatar
WillT
Icon for Community Admin rankCommunity Admin
10 years ago

Customers who bought multiple products

Hi everyone. Worked on a little problem recently to try and figure out "customers who bought combinations of products". I have seen plenty of posts and great patterns on Basket Analysis (e.g. DAX Pat...
Show and Tell
KrishnaKalyan's avatar
KrishnaKalyan
Regular Visitor
5 years ago

Hi,

 

I have a similar request, but my users want to see the customer list and the amounts per product as well in a pivot table

My data has Columns: Year, Customer No, Customer Name, Product, and Amount.

I'm thinking if I can get a unique customer list in a calculated table dynamically based on the product selection and year selection, I can use the relations between the table and get the visualizations working.

 

Could someone kindly help in getting this dynamic table? Even if anyone has a better solution, I would be more than happy to take it. 

 

Thank You & Regards,

Krishna Kalyan