cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adam_macs
Helper I
Helper I

How to report what customers have purchased individual products

I have a request from my company that they wish to analyse and filter on what customers purchase:

  • only one specific product and no others
  • one product + another
  • all products

With data structured like below, does anyone have any advice on how I should approach this? My thought was to create TRUE/FALSE columns for all the different products, however, this could get messy if we have dozens of products. 

 

adam_macs_0-1678199637776.png

1 ACCEPTED SOLUTION
AdaKAda
Helper I
Helper I

This looks like the classic 'basket analysis' pattern, you can find it described in great detail here: 

 

https://www.daxpatterns.com/basket-analysis/

 

If it's just a matter of hardcoding a few specific product combinations, measures using filter on product name would be enough though. 

View solution in original post

1 REPLY 1
AdaKAda
Helper I
Helper I

This looks like the classic 'basket analysis' pattern, you can find it described in great detail here: 

 

https://www.daxpatterns.com/basket-analysis/

 

If it's just a matter of hardcoding a few specific product combinations, measures using filter on product name would be enough though. 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors