Calculate DAX Function and Filter Context - ALLSELECTED and KEEPFILTERS

) Introduction.
) Filter Context, First Look.
) CALCULATE to change Filter Context with a Boolean Filter.
) CALCULATE and CALCULATETABLE DAX Functions.
) What is a Boolean Filter?.
) First look at the Overwrite Operator in CALCULATE. Merge the Internal Filter Context and External Filter Context.
) CALCULATETABLE to change Filter Context with a Boolean Filter.
) CALCULATE to perform Context Transition.
) All Measures have a Hidden CALCULATE Function.
) Boolean Filter is always converted to a FILTER & ALL DAX Function construction.
) DAX Studio to look at FILTER and ALL Equivalent for a Boolean Filter.
) VALUES rather than ALL in first argument of FILTER.
) VALUES Function to bring a Variable into a Formula and use it as a condition for a Boolean Filter.
) AND Logical Test – 4 Examples.
) Can NOT use two different columns in a Boolean Filters.
) OR Logical Test Boolean Formulas.
) Can NOT Directly Compare Two Columns as a Boolean Filter. Keystone Pricing Examples..
) DAX Studio to see how FILTER and ALL delivers a table where we directly compare two columns for a DAX Measure.
) Can NOT use MIN or MAX or other aggregate functions as a condition for a Boolean Filter.
) Frequency Distribution DAX Formula. Learn about the COUNTROWS Function.
) ALL DAX Function & Grand Totals. Learn about the Remove Operator in ALL DAX Function when you use it in the Filter argument of CALCULATE.
) Look at Data Model for Power BI File for looking more closely at the Overwrite Operator.
) Overwrite Operation. Second look at the Overwrite Operator in CALCULATE. Merge the Internal Filter Context and External Filter Context into the Final Filter Context.
) Reminder about ALL before we learn about ALLSELECTED. What is the problem that ALLSELECTED can solve?.
) ALLSELECTED to create Grand Totals that respect the filtering in the PivotTable.
) Context Transition is how ALLSELECTED gets to the Grand Total Cell Filter Context.
) Hidden Context Transition for Measures in an Excel PivotTable or Power BI Visual.
) ALLSELECTED and Context Transition, the Full Story.
) 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.
) Use ALLSELECTED DAX Function in CALCULATE Measures.
) ALLSELECTED Functions works on Cross Tab Reports too !.
) 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.
) Look at new Data Model for next example.
)First example of the KEEPFILTERS DAX Function to force an AND Logical Test rather than an Overwrite Operation.
) What is a Complex Filter? What is a Complex Filter Reduction Error?.
) How KEEPFILTERS can help solve a Complex Filter Reduction Error for Year Column in AVERAGEX..
) Why KEEPFILTERS is used in the New Quick Measure in Power BI.
) How KEEPFILTERS can help solve a Complex Filter Reduction Error for Year Column and Month Column in CROSSJOIN in AVERAGEX.
) Data Model solution to solve Complex Filter Reduction Error.
) Determine if a filter is a complex filter with CROSSJOIN.
) Expanded Table Concept & Relationships..
) Table Filters & Expanded Table as filters in the Filter argument of CALCULATE.
) Expanded Table Filter with ALL Function. 2 Examples.
) Table Filter to send a filter backwards across a Many-To-One Relationship. Great Visual for understanding this filter.
) ALLEXCEPT DAX Function with an Expanded Column.
) Examples of Time Intelligence Functions.
) Measure for Revenue from Last Year. SAMPERIODLASTYEAR.
) Measure for Revenue for Last Month. DATEADD and ISFILTERED DAX Functions.
) Compare Excel and DAX Formulas.
) Measure for % Change using IF, BLANK, DIVIDE and HASONEVALUE DAX Functions.
) DAX Formula Evaluation Context Summary.