add_percent_of_total
Create a percent-of-total measure for a base measure across a dimension, with configurable scope (ALL, ALLSELECTED, ALLEXCEPT) to control the total context.
Instructions
Generate a percent-of-total measure for a base measure over a dimension. scope = ALL | ALLSELECTED | ALLEXCEPT (default ALLSELECTED).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| scope | No | ALL | ALLSELECTED | ALLEXCEPT (default ALLSELECTED) | |
| table | Yes | home table | |
| dimension | Yes | dimension column as Table[Column] | |
| sessionId | Yes | ||
| baseMeasure | Yes | base measure name |