The DAX CALCULATE Function

We start a deep dive into what an evaluation context is and then move into the filter context.

We continue our deep dive into the filter context.

In this lecture we discuss the other half of the evaluation context, the row context

This lecture begins an in-depth discussion of context transitioning that occurs when CALCULATE is used inside a row context and one particular problem it can cause

We continue our in-depth discussion of context transitioning that occurs when CALCULATE is used inside a row context and one particular problem it can cause

We demonstrate a way for identifying duplicate rows in your tables using Power Query

This is a brief introduction to the CALCULATE function

This lecture talks about the role the FILTER statement plays in the CALCULATE statement

Here we present a brief summary of how filters work in a CALCULATE statement

It's important to understand the order of execution of the parameters contained in a CALCULATE, and how nested CALCULATE statements might impact that. We also show how to mimic a filter context set in Power BI.

We discuss what a CALCULATE modifier is using the ALL and VALUES function

We continue our discussion on what a CALCULATE modifier is using the ALL and VALUES function and some practice exercises

We discuss the KEEPFILTERS modifier in this lecture

We continue our discussion on CALCULATE modifiers by discussing the USERELATIONSHIP function

We continue our discussion on CALCULATE modifiers by discussing the CROSSFILTER function; a sometimes great alternative to bi-directional filters in your model

In this lecture we discuss the fascinating, powerful and dangerous ALLSELECTED modifier function

Here we review a summary of how CALCULATE evaluates an expression

Expanded tables are a core concept in DAX and we discuss the impact it could have when filtering in a CALCULATE statement

CALCULATETABLE is sort of a mystery function that isn't widely known or used. But, in some scenarios, it can be much more efficient than using FILTER.

Test your knowledge with 20 questions

This exercise and exercise 2 both use the Contoso database that can be downloaded as a resource. The Contoso - Solution database contains the solution to the two exercises.

This exercise builds on exercise #1. The database used for this exercise is the same for exercise #1 and can be downloaded as a resource in exercise #1.

Exercise 3. The database used can be downloaded as a resource.

Exercise 4. The database used can be downloaded as a resource.

Exercise 5. The database for this exercise can be downloaded as a resource.

A tricky exercise where one query using FILTER does not return the same number of rows as the same query using CALCULATETABLE