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.
- About the Static segmentation pattern
- Basic pattern
- Price ranges by category
- Price ranges on large tables