add_abc_classification
Classify entities in a Power BI table into A, B, or C classes using Pareto analysis with configurable cumulative thresholds.
Instructions
Generate ABC (Pareto) classification: a dynamic class measure plus a calculated class table. aThreshold / bThreshold are cumulative-share cut-offs (e.g. 0.7 and 0.9); the rest fall into C.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| key | Yes | entity key column as Table[Column] | |
| sessionId | Yes | ||
| aThreshold | No | A cumulative-share threshold (default 0.7) | |
| bThreshold | No | B cumulative-share threshold (default 0.9) | |
| entityTable | Yes | entity / home table | |
| valueMeasure | Yes | value measure to Pareto on, e.g. Total Sales | |
| classTableName | No | name for the class table (optional) |