Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.