Forum Discussion
Helper IINeed help with Cross-Selling Analysis
Hey,
trying to understand what our customers really want I am trying to set up a cross-selling analysis.
If already found several good explanations for doing so, just like here: https://www.youtube.com/watch?v=VE0V_WhzFOI
But that's not particular what I wanted. I want to take the sales volumne per product into this matrix analysis.
For example, one customer buys 2 pieces of product A and 3 pieces of product B. Another one buys 1 piece of product C and 3 pieces of product B. Then I would expect something like that:
| Product | Product A | Product B | Product C | |
| Quantity | 2 | 3 | 1 | |
| Product A | 2 | 1 | ||
| Product B | 3 | 1 | 1 | |
| Product C | 1 | 1 |
Does anyone unterstand my issue and is able to help me?
2 Replies
- amitchandak
Super User
TOK , refer this for Market Basket Analysis
https://finance-bi.com/power-bi-basket-analysis/
https://businessintelligist.com/2017/03/27/market-basket-analysis-using-power-bi/
https://www.daxpatterns.com/usecases/market-basket-analysis/
https://www.mssqltips.com/sqlservertip/5428/market-basket-analysis-in-r-and-power-bi/Please Watch/Like/Share My webinar on Time Intelligence: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
My Youtube Tips at: https://www.youtube.com/playlist?list=PLPaNVDMhUXGYrm5rm6ME6rjzKGSvT9Jmy
Appreciate your Kudos. 
v-juanli-msftCommunity Support
Hi TOK
Do you filter specific customers on the report and show the matrix as you provide above?
It seems you need to analyze the cross-selling based on selected customers, right?
Best Regards
Maggie
