Locked lesson.
About this lesson
Creating measures for our sample model
Exercise files
Download this lesson’s related exercise files.
4-02 Begin.pbix406.6 KB 4-02 Complete.pbix
407.1 KB
Quick reference
Basic Measures - Application
Creating measures for our sample model
When to use
You want to practice creating basic measure patterns
Instructions
Creating basic measures:
- Right-click the table you want to hold the measure -> Add measure
- Enter the formula for the measure
- Set the default formatting options
Sample measures
- Budgets $ = SUM(Budgets[Amount]
- Sales $ = SUM(Sales[Amount])
- Sales (Units) = COUNT(Sales[Units])
- Last Sale = LASTDATE(Calendar[Date])
Applying measures:
- Replace all numeric columns in the visual with the appropriate measure
Modifying Measures:
Last Sale is not correct, it’s giving the last date in the calendar, not the last sale
- Select the measure
- Change the formula to LASTDATE(Sales[Date])
- Change the Home table to Sales
Units should be a sum, not a count:
- Select the measure and change the formula to =SUM(Sales[Units])
Hints & tips
- By right-clicking the table in the fields list and choosing Add Measure, the measure is automatically added to the correct table
- Updating a formula in the measure updates all visuals immediately
- Numeric fields in a table can be hidden to force you to use your measures
Sorry, we don’t have a transcript for this lesson yet.
Lesson notes are only available for subscribers.