Need help with Cross-Selling Analysis

[TOK]

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?

[v-juanli-msft]

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

[amitchandak]

@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-Y...
My Youtube Tips at: https://www.youtube.com/playlist?list=PLPaNVDMhUXGYrm5rm6ME6rjzKGSvT9Jmy

Appreciate your Kudos.