Get startedGet started for free

SUMMARIZE() the facts

Data tables sometimes contain repetitive rows of information and need to be condensed down for reporting. The SUMMARIZE() function can be used to group a table by one or more columns, condensing tables down. In this scenario, you're going to have a look at the Profit Ratio from Chapter 2 again, and visualize how it changed over time for the California sales. One approach to do this, is by creating a new table containing only the data you need, without the need of specifying an additional relationship, improving performance of your report.

This exercise is part of the course

Intermediate DAX in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise