In this video, the instructor revisits the use of FILTER within a CALCULATE function, and illustrates exactly how the FILTER function impacts the way measures are calculated behind the scenes.
- [Instructor] All right, so in the last video,…we introduced the filter function,…we talked about what it was all about,…explained some of the nuances with it,…and then walked through an example of that.…Wasn't really the most applicable.…So in this lecture, let's talk about a much more useful…and much more fun way to use that filter function.…So this is a really cool example,…and what we're gonna try…to do is create a way for users…to interact with our pivot table…using a disconnected slicer.…And you'll see what I mean.…
We're gonna walk through the five steps here,…and then we'll replicate them over…in our data model workbook.…So step one, we're gonna create an Excel table,…containing a list of values that we'd…like to use as thresholds or parameters.…And this depends on what you're trying to do.…In the example we're gonna show,…the idea is to create a price threshold,…so that we can see how many transactions occurred…for products below certain price levels.…And since we have a good sense of the distribution…
- 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.