Quick summary
The SUM function in Power BI lets you aggregate column values using a DAX measure created in the Modelling tab. Once created, the measure can be applied to any visual in your report to display summed totals instantly.
Steps
- Click on the visual and navigate to the Modelling tab.
- Select New Measure from the Modelling tab options.
- Type the DAX code in the formula bar and select the SUM function.
- Select the column name you want to sum.
- Click the check icon to commit the measure.
- Use the new measure in any visual to sum values across your Power BI report.
