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.

Students have access to a private discussion area where they can interact with the instructors asking questions related to the lectures and the exercises.


  • 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