ABC Classification

Back

ABC Classification

Dynamic ABC Classification

DAX

Overview

Features

Prompts

Help

Key Features

ABC analysis answers which products drive 70% of revenue or which customers represent your A-class — but the static calculated column approach ignores your slicers. A product that is A-class globally may become B-class when filtered to a specific region or channel. Building the correct dynamic pattern requires a ranking approach that responds to slicer context, a configuration table, model registration, and color-coded visuals. This skill builds everything end-to-end in one command — run it with /abc-classification.

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 Configuration calculated table with A/B thresholds (default 70% / 90%, customizable)
Generates 11 DAX measures — cumulated percentage, class assignment, color, item counts per class, sales per class, and switch measures for the summary matrix
Creates two visuals on the target page: a 3-row summary matrix and a color-coded bar chart (green=A, amber=B, red=C)
Patches the model definition with the required table registration

What you get

ABC Configuration table — calculated table with A/B thresholds, editable post-deploy
11 DAX measures — cumulated percentage, 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 by class

Explore more in this category

Pareto Chart

DAX

Add a Pareto (80/20) combo chart to any report page

Rolling Averages Kit

DAX

Add 3-month, 6-month, and 12-month rolling averages plus a running total to any measure in your model

Time Intelligence Kit

DAX

Generate 23 time intelligence items that apply to every measure in your model automatically

Tool Information

Skill

39 USD

Bundle (All skills)

129 USD