02. Filter Context

The "Brain" of DAX. Learn how to manipulate, remove, and modify filters.

CALCULATE (The King)

The only function that can modify the filter context.

FILTER (Iterator)

Iterating through a table to keep specific rows based on logic.

ALL / ALLEXCEPT

How to remove filters to calculate Grand Totals and Subtotals.

VALUES vs DISTINCT

Handling unique lists and the "Blank Row" behavior.

RELATED / RELATEDTABLE

Fetching data from other tables using relationships.

⬅ Back to DAX Menu