DAX Patterns: Static segmentation

These are in-depth video lectures of the Static segmentation pattern.

This pattern classifies numerical values into ranges. A typical example is the analysis of sales by price range. You do not want to slice the data by individual price; instead you want to simplify the analysis by grouping prices within ranges of prices. The price ranges are stored in a configuration table and the pattern requires the model to be entirely data-driven. In other words, when the configuration table is updated, the model is updated automatically without requiring any change to the DAX code.

Collapse allCurriculum

  • Static segmentation

    • About the Static segmentation pattern
    • Introduction
    • Basic pattern
    • Price ranges by category
    • Price ranges on large tables


This content is also available in the collection:
DAX Patterns collection
Student Rating
7 ratings
4-star Reviews (1 of 3)
  • Genadiy Tsvetkov (Dec 17, 2023)

    Great pattern! a Practical Exercises section would be benefitial