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