In this video, the instructor demonstrates how to use the data model's AutoSum feature to quickly create basic measures using common functions (SUM, COUNT, AVERAGE, and so on).
- [Instructor] Shifting gears into explicit measures.…There are a couple of ways to create explicit measures.…There is the lazy way and there's the proper way.…So right now, I'm gonna show you very quickly the lazy way,…and then we won't use this approach ever again…through the rest of the course.…But I feel obligated to show you…just so that you know it exist.…Now, consider this Data View from the data model.…Note this pane at the bottom,…which you may have seen earlier in the course…and been a little confused by, which I don't blame you.…
It's kind of a strange layout,…but they call that the Measures Pane…or the Calculation Area,…which you can actually turn it on and off…right here in this button that says Calculation Area…in the Home tab.…And as we start creating measures,…they'll start populating down here in the Measures Pane.…You could see down here…there's actually a Revenue Measure that had been created…for this screenshot, and it just sits down here…and it tells you, hey, there's a measure that exists…
Author
Released
5/9/2018- Power Pivots versus normal pivots
- Creating calculated columns and measures
- Power Pivot and DAX best practices
- Math, stats, and COUNT functions
- CALCULATE, FILTER, and ALL functions
- Joining data with RELATED
- Using iterator functions (SUMX and RANKX)
- Time intelligence formulas
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2016 Essential Training
with Dennis Taylor8h 53m Beginner -
Excel Tips Weekly
with Dennis Taylor28h 53m Intermediate -
Excel 2013: Data Validation
with Dennis Taylor1h 5m Intermediate
-
Introduction
-
Welcome56s
-
-
1. Getting Started
-
Set expectations1m 46s
-
2. Power Pivot and DAX 101
-
Create a Power Pivot table5m 27s
-
Calculated columns8m 39s
-
DAX measures2m 24s
-
Create implicit measures1m 59s
-
Understand filter context9m 18s
-
Power Pivot best practices1m 48s
-
3. Common DAX Functions
-
Basic math and stats functions12m 45s
-
Switch and Switch (TRUE)10m 33s
-
Text functions10m 53s
-
The CALCULATE function14m 39s
-
Join data with RELATED3m 39s
-
Iterator ("X") functions: SUMX12m 20s
-
Time intelligence formulas17m 2s
-
DAX best practices2m 3s
-
Conclusion
-
Final section53s
-
Data visualization options4m 24s
-
Conclusion24s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Create explicit measures (AutoSum)