Completed
) Introduction
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Calculate DAX Function and Filter Context - ALLSELECTED and KEEPFILTERS
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Filter Context, First Look
- 3 ) CALCULATE to change Filter Context with a Boolean Filter
- 4 ) CALCULATE and CALCULATETABLE DAX Functions
- 5 ) What is a Boolean Filter?
- 6 ) First look at the Overwrite Operator in CALCULATE. Merge the Internal Filter Context and External Filter Context
- 7 ) CALCULATETABLE to change Filter Context with a Boolean Filter
- 8 ) CALCULATE to perform Context Transition
- 9 ) All Measures have a Hidden CALCULATE Function
- 10 ) Boolean Filter is always converted to a FILTER & ALL DAX Function construction
- 11 ) DAX Studio to look at FILTER and ALL Equivalent for a Boolean Filter
- 12 ) VALUES rather than ALL in first argument of FILTER
- 13 ) VALUES Function to bring a Variable into a Formula and use it as a condition for a Boolean Filter
- 14 ) AND Logical Test – 4 Examples
- 15 ) Can NOT use two different columns in a Boolean Filters
- 16 ) OR Logical Test Boolean Formulas
- 17 ) Can NOT Directly Compare Two Columns as a Boolean Filter. Keystone Pricing Examples.
- 18 ) DAX Studio to see how FILTER and ALL delivers a table where we directly compare two columns for a DAX Measure
- 19 ) Can NOT use MIN or MAX or other aggregate functions as a condition for a Boolean Filter
- 20 ) Frequency Distribution DAX Formula. Learn about the COUNTROWS Function
- 21 ) ALL DAX Function & Grand Totals. Learn about the Remove Operator in ALL DAX Function when you use it in the Filter argument of CALCULATE
- 22 ) Look at Data Model for Power BI File for looking more closely at the Overwrite Operator
- 23 ) Overwrite Operation. Second look at the Overwrite Operator in CALCULATE. Merge the Internal Filter Context and External Filter Context into the Final Filter Context
- 24 ) Reminder about ALL before we learn about ALLSELECTED. What is the problem that ALLSELECTED can solve?
- 25 ) ALLSELECTED to create Grand Totals that respect the filtering in the PivotTable
- 26 ) Context Transition is how ALLSELECTED gets to the Grand Total Cell Filter Context
- 27 ) Hidden Context Transition for Measures in an Excel PivotTable or Power BI Visual
- 28 ) ALLSELECTED and Context Transition, the Full Story
- 29 ) Visual Example of when ALLSELECTED will not get back to the Filter Context of the Grand Total Cell in the Excel PivotTable or Power BI Visual
- 30 ) Use ALLSELECTED DAX Function in CALCULATE Measures
- 31 ) ALLSELECTED Functions works on Cross Tab Reports too !
- 32 ) Example of Measure in Power BI Visual that uses ALLSELECTED and will not get back to the Filter Context of the Grand Total Cell Power BI Visual
- 33 ) Look at new Data Model for next example
- 34 )First example of the KEEPFILTERS DAX Function to force an AND Logical Test rather than an Overwrite Operation
- 35 ) What is a Complex Filter? What is a Complex Filter Reduction Error?
- 36 ) How KEEPFILTERS can help solve a Complex Filter Reduction Error for Year Column in AVERAGEX.
- 37 ) Why KEEPFILTERS is used in the New Quick Measure in Power BI
- 38 ) How KEEPFILTERS can help solve a Complex Filter Reduction Error for Year Column and Month Column in CROSSJOIN in AVERAGEX
- 39 ) Data Model solution to solve Complex Filter Reduction Error
- 40 ) Determine if a filter is a complex filter with CROSSJOIN
- 41 ) Expanded Table Concept & Relationships.
- 42 ) Table Filters & Expanded Table as filters in the Filter argument of CALCULATE
- 43 ) Expanded Table Filter with ALL Function. 2 Examples
- 44 ) Table Filter to send a filter backwards across a Many-To-One Relationship. Great Visual for understanding this filter
- 45 ) ALLEXCEPT DAX Function with an Expanded Column
- 46 ) Examples of Time Intelligence Functions
- 47 ) Measure for Revenue from Last Year. SAMPERIODLASTYEAR
- 48 ) Measure for Revenue for Last Month. DATEADD and ISFILTERED DAX Functions
- 49 ) Compare Excel and DAX Formulas
- 50 ) Measure for % Change using IF, BLANK, DIVIDE and HASONEVALUE DAX Functions
- 51 ) DAX Formula Evaluation Context Summary
