Elements of DAX 06-13 CALCULATE() Inside CALCULATE()

Often making a single change to the filters simply is not enough, sometimes you will need to Revise the filters then Revise them again. The behavior here is not incredibly difficult but it is unintuitive and often new people will find their guesses for a given result are the exact opposite of what someone might expect. In this video Brian Grant will walk you through the mechanics of this situation and help you get a better sense of why the unexpected outcome is actually completely logical and surprisingly easy to understand.

[gauravguliani]

The sound for this came from left side of earphones alone
Excellent content Brian

[rick_.]

Thank you for these videos! The repition with small example tables is really helpful.

[MisterT]

Really happy with the upload! Such a great and original way of explaining DAX!

[kerryjiang]

So glad you are uploaded. I am on 06-11 now. :-))

[bravucod]

Phenomenal. Thanks for offering such a great content!

[pedropradocarvalho]

why is this video muted for me? I hear no sound at all! :(

[IoriYagamiKOF]

what would hapen if you didn't have the alll in the inner filter ??

[azizquazi]

Can we get the working files (PBIX) to follow along? Thanks.

[totvabe]

In first example, what if in line 8 we had
Mini[Shift]
instead of
ALL( Mini[Shift] )
, not ignoring the first filter (line 15) we had. Would have we got the intersection of filters (Blank) as a result?

Thanks!

[seanmen]

I notice in all these examples, the initial filter context is always nothing. Just curious what will happen if you have got a filter context in there from the beginning. Could you do an example like that?

[mgray]

If one calculate overwrites the other why would you write a measure with nested calculate statements? Is this effectively what happens when you reference a measure in a second measure?
BTW - great series of videos!