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.