pbi_create_contribution_measure
Create a DAX measure that calculates each row's contribution as a percentage of the total, using specified dimension columns for the denominator scope.
Instructions
Create a %-of-total contribution measure.
DAX template:
DIVIDE([{base}], CALCULATE([{base}], ALL({scope_columns})))
scope_columns defines the denominator scope — typically the dimension
columns whose total you want each row to be a percentage of (e.g.
["Categorie.Nom catégorie"] for "this category's % of all categories").
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| overwrite | No | ||
| base_measure | Yes | ||
| measure_name | No | ||
| format_string | No | 0.00% | |
| scope_columns | Yes | ||
| display_folder | No | Contribution |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |