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
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors