In this video, the instructor briefly introduces implicit measures, which are measures that are automatically created by Excel when you drag a field in the PivotTable field list.
- [Instructor] Time to talk about something called…an implicit measure.…It sounds very complicated, very scientific,…but the good news is this may be the easiest lecture…in the entire course, very simple to do.…Looking at our pivot table field list here,…step one is to check the box next to a value field…in a data table or grab that field and drag it…into the Values field of the pivot table.…Step two, there is no step two.…You're done, you literally just created an implicit measure.…
You're probably wondering,…why is Chris focusing so much on measures?…This is ridiculous and it's exactly how I would've…created a simple calculated field in a normal pivot table,…and you're right.…That's why we've got some important things to note.…Before you start celebrating, there is a catch here.…When you drag that raw data field or check the box,…to put it in the value section of the pivot,…you've created an implicit measure,…and there's nothing wrong, there's nothing incorrect…about implicit measures.…
They'll show you the correct answers,…
- 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
1. Getting Started
Set expectations1m 46s
2. Power Pivot and DAX 101
3. Common DAX Functions
- 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.Cancel
Take 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.