ABC Classification
Dynamic ABC Classification
DAX
Overview
Features
Prompts
Troubleshooting
Key Features
ABC analysis is one of the most requested analytics patterns in Power BI — which products drive 70% of revenue? Which customers represent your A-class? The static calculated column approach is fast but ignores your slicers: apply a category filter and every product stays in the same class regardless of context. The SQLBI Dynamic Approach uses WINDOW functions for real-time reclassification — a product that is A-class globally may become B-class when filtered to a specific region or channel. But writing the WINDOW-based DAX correctly, creating the Configuration table, patching model.tmdl, and building the color-coded visuals takes hours. This skill builds everything end-to-end in one command.
How it works
Type /abc-classification, provide your dimension and measure, and the skill builds everything:
Scans the model to validate the dimension table, column, and base measure
Creates an
ABC Configurationcalculated table with A/B thresholds (default 70% / 90%, customizable)Generates 11 DAX measures —
ABC Cumulated %,ABC Class,ABC Color, item counts per class, sales per class, and switch measures for the summary matrixCreates two visuals on the target page: a 3-row summary matrix (class / item count / sales) and a color-coded bar chart (bars sorted by measure, colored green=A, amber=B, red=C)
Patches
model.tmdlwith the requiredref table 'ABC Configuration'entry
What you get
ABC Configurationtable — calculated table with A/B thresholds, editable post-deploy for threshold tuning11 DAX measures — cumulated %, class assignment, color, item counts per class, sales per class, and switch measures
Summary matrix — 3-row matrix showing class / item count / sales in the current filter context
Color-coded bar chart — dimension items sorted by measure descending, bars colored green/amber/red by class
