Elements of DAX 06-17 CALCULATE() With Two Aggregators

So far all of our sub expression have been dead simple: a Derivation inside and Aggregation Iterator. While this is great for focusing on the mechanics of Revisers it might give the false impression that this is some sort of requirement when that couldn't be farther from the truth. In this video Brian Grant will show you how you can pass in a (slightly) more complex sub expression with two Aggregation Iterators and Derivations to see that the behavior is the same, there's just more steps. Getting comfortable with sub expressions that come in all shapes and sizes will be critical as you start to get a tactile sense for how the language works.

[beginho]

Hello Brian, The 6th chapter seems to be finished?
Look forward the 7th and further chapters, you demystify the Evaluation Context!

[beginho]

Great Courses!
Thanks a lot Brian!
your teaching method "step by step" makes me eaiser to under the logic.

[MilhouseBS]

And we could optimize by iterating over VALUES(Mini[PricePer]) to reduce the size of the temp tables?

[ajieapen]

I am simply in love with your teaching method... Hope it's not patented... :)

[vijaypalmanit]

In all the examples result of FILTER argument is a one column table, what will happen if result of FILTER is a multi column table with multiple rows.