cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TOK
Helper II
Helper II

Need 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 AProduct BProduct C
 Quantity231
Product A2 1 
Product B31 1
Product C1 1 

 

Does anyone unterstand my issue and is able to help me?

2 REPLIES 2
v-juanli-msft
Community Support
Community 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

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors