add_percent_of_parent
Generates a percent-of-parent measure for a hierarchy, computing each level's share of its parent. Provide hierarchy columns from top level to leaf to create the Power BI measure.
Instructions
Generate a percent-of-parent measure over a hierarchy. hierarchyColumns is a comma-separated list of Table[Column] from top level to leaf, e.g. Product[Category], Product[Subcategory], Product[Product].
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | home table | |
| sessionId | Yes | ||
| baseMeasure | Yes | base measure name | |
| hierarchyColumns | Yes | comma-separated Table[Column] hierarchy levels, top to leaf |