Basket Analysis DAX pattern
This pattern is a specialization of the Survey pattern.
-
2015 Basket Analysis explained on the DAX patterns site.
-
Basic pattern example
The key feature is a copy of the Product table, which contains the same data and has the prefix ‘Filter’ before all the table and column names. The relationship between the Sales table and the Filter Product table is inactive. This Filter table enables use of a dual filter on products and/or their attributes.
-
Complete pattern example
This sample shows, in separate tabs, measures based on: -
- Orders
- Customers
- Orders or Customers with both Products.
-
-
2019 Sequential Basket Analysis explained by Davis Zhang.
This article extends ‘Basket Analysis’ by taking into account the chronological order in which customers purchase different products.
-
2014 Basket Analysis explained by Gerhard Brueckl.