This lesson's interactive features are locked, please to keep using them

Measures

Calculated columns and measures both perform calculations, but they're quite different.

A "calculated column" is stored in your model and evaluated for each row in a table. A "measure" is calculated on the fly as a total, updating dynamically as you interact with your report.

Columns are row-by-row; measures are context-by-context.

Assignment

In the Model view, click on the sales table and select "New measure" from the top ribbon.
In the Formula bar, enter the formula for total revenue:
```
total_revenue = SUM(sales[discounted_price])
```
Notice that this doesn't generate an entire column of data – the measure represents a single aggregated value!
Go back to the Card visual we just created that's missing data. Drag the total_revenue measure from the sales table into it. Yay! Aggregated metrics!

Save the project and, from the course directory, submit the CLI tests.