Power BI Desktop has a handy feature for showing percentages when numeric measures or column aggregations are placed in the Values area of visualizations. This feature allows you to right-click the measure or column and choose Show value as and then Percent of grand total, Percent of column total, and Percent of row total, depending on the type of visual. This is a nice, easy method to compute and display these percentages. However, not all places where DAX is used has such a convenient shortcut. Therefore, this recipe demonstrates how to compute these percentages using just plain old DAX.
To prepare for this recipe, perform the following steps:
- Open Power BI Desktop.
- Use an Enter Data...