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:
Does anyone unterstand my issue and is able to help me?
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?
@TOK , refer this for Market Basket Analysishttps://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=PLPaNVDMhUXGYrm5rm6ME6rjzKGSvT9JmyAppreciate your Kudos.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.