DAX Patterns: Basket analysis

These are in-depth video lectures of the Basket analysis pattern.

The goal of basket analysis is to analyze relationships between events. A typical example is to analyze which products are frequently purchased together. This means they are in the same “basket”, hence the name of this pattern. Two products are related when they are present in the same basket. In other words, the event granularity is the purchase of a product. The basket can be the most intuitive, like a sales order; but the basket can also be a customer; In that case, products are related if they are purchased by the same customer, albeit across different orders.

Collapse allCurriculum

  • Basket analysis

    • About the Basket analysis pattern
    • Introduction
    • Defining association rules metrics
    • Optimizing the calculations


This content is also available in the collection:
DAX Patterns collection
Student Rating
3 ratings
Student Reviews (1)
  • Ivan Yu (Jun 15, 2021)

    It is very good that you have Excel version of the Code as sometimes, organization don't use POWER BI but Tableau. But they still use Excel all the time.