Percent of Total
The Percent of Total function returns the percentage of each value in the input series out of the total sum of the values in the input series.
The Percent of Total function requires the following input series:
- d0 - The set of data values for which the formula is calculated.
The Percent of Total function requires the following parameters:
- Alignments... (One or More, Optional) – Hierarchy placeholders to be used as the alignment axis.
3.1. Add the formula
The Percent of Total function generates a result set in a decimal format, where each value represents a portion of the total (1).
4.1. Change the presentation (optional)
For example, a common practice is to use the calculated values for percentage labels:
- Change the formatting on the measure.
- Hide the measure.
- Add the measure values to the data point labels.