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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
