Filter Context in DAX

Understanding the difference between a row context and a filter context is the first and most important concept to learn to use DAX correctly. This video introduces the filter context.

[tyronefrielinghaus]

The step by step and zooming in are fantastic. Much better to go slow, but thoroughly.

[karannchew]

Notes for revision.

13:03
Filter context is automatically propagated from a table to another,
following the relationship.

Arrow of relationship indicates propagation of filter context.

Filterable (broken down) based on related table:
filtering the Product, Customer and Dates table.

---
*Filter, **Measure, **Calculate*

First, we define a measure:
Sales Amt =
SUMX( Sales,
Sales[qty] * Sales[price] )

Then use the measure in calculate, that can include filters.

CALCULATE (
[Sale Amt],
Customer [continent]="Europe")

Here, Sales table, included in [Sale Amt], will first be filtered by whatever in the visual filter.
Then, the additonal filter in this calculate i.e. Customer [continent]="Europe") is applied to the table.
Only then SUMX run its expression (row by row).

[TheBallboy]

Mannnn! I was just banging my head against the wall reading " The Definitive Guide to Tax." But now, having watched this, I wanna go and explain it to everyone. Great clarification. Looking forward to Context transition and the bastard invisible Calculate in measures and dependencies.

[mikeycbd]

Excellent. I went straight to my dashboard and grabbed the code, it's much easier to understand after following your courses.

[kebincui]

Excellent explantaion about Filter Context which is one of the key fundamental concepts in DAX. Thanks Alberto

[kunwang]

Really awesome material on DAX. From DAX example to Row Context, Now filter context. I assume the next video will be on Context Transition.😄😁

[danew]

Thank you sir, I’ve been developing SSAS tabular cube and recently Power BI, I never throughly understand DAX language, all my development in the past involve tons of google and try and error.. I really appreciate this series of tutorial you put out, I’m re-learning the fundamental and syntax start to make sense !

[gborka]

Thank you for sharing, really great idea to build the understanding layer by layer:
*Row Context
*Filter Context
*CALCULATE Function
*Context Transition

[mmmommm]

Ye, this is the best DAX channel without a doubt! Ty Mr. Ferrari!

[augustotanaka]

Excellent video, simple and straight to the point, taking into consideration all the relevant related topics

[elicesroman]

Thanks for your dedication and enthusiasm. Brilliant Video and Learning paths - row then filter then calculate and then context transition. bravo

[adamsobanski]

literally got job based on these videos, thank you very much mr. Alberto

[wayneedmondson]

Awesome explanation and discussion! Really helps to hear your description along with the examples. Many thanks. Thumbs up!!

[csgexec]

Great job! I think “Row” context is better thought of as “Record” context.

[oliveroshea]

more nourishing DAX goodness from SQLBI!

[sandeepbarge]

Thanks!, loved the way details about filter context are covered!

[kunwang]

And congratulations on your coming 50K subscribers.

[jonathanchem]

Excellent material. Very clear and informative

[diegotroncozogonzalez]

This content is pure gold
Thanks a lot!

[cesarebellentani]

Grazie!!! bravissimo, chiaro come sempre!!!