Row Context - (1.12) Ultimate Beginners Guide to DAX 2020

Follow along to the beginners guide DAX tutorials by using the demo data available for download. Enjoy!

Details of what you will learn during this course
Learn - what DAX is and why you need to learn it when using Power BI
Learn - the basics of DAX calculations
Understand - formula syntax, writing comments & variables
Review - how the data model and DAX calculations work together
Learn - what the most important concept of DAX is - CONTEXT
Understand - what the CALCULATE statement does
Learn - what table functions are and when to use them
Review - time intelligence functions
Understand - how important learning DAX well is when using Power BI

Here are the specifics for the course
Learn how to;
Use DAX formula with Power BI
When and where to use DAX functions
Utilise some of the great features built into the DAX formula bar
Use the data model in combination with DAX formula
Understand the concept of CONTEXT
Use the CALCULATE statement
Create filters using table functions
Incorporate time intelligence functions in your analysis
Become a DAX master by combining patterns of DAX formula

***** Video Details *****
0:43 - Understanding Row Context With SUMX
2:32 - Other Applications Of Row Context
3:41 - Row Context On Total Quantity
6:46 - Iterating Functions Vs Aggregating Functions

***** Learning Power BI? *****

***** Related Links *****

***** Related Course Modules *****

***** Related Support Forum Posts *****

[EnterpriseDNA]

Learning Power BI?







Related Links

Related Course Modules

Related Support Forum Posts

[dancorwin]

Holy crap this is FINALLY starting to make sense. That renaming to aggregation and iteration really helped me wrap my head around it. Thank you, this is finally starting to gel in my head and I have you to thank for it!

And I also really appreciate that you got the same result with two different methods and explained why they are different, that also really helps me get the reason of why you'd use one over the other!

[andreasmohr]

Really setting the base for me to get things straight. Thank you.

[jimtitus]

Easily the best explanation I've found on evaluation, filter & row context. Thanks!!

[sreekumarmenonk]

really nice.. love your work:)
i have a question..
is it right to think that a
Calculated Measure => an explicit Filter Context
while a
Calculated Column => an explicit Row Context?
in other words, a DAX function that invokes the Filter or Row context engine, it is internally calling a pre defied Calculated Measure and a Calculated Column?

Does is this also mean that you don't really have to have create a Calculated Column to invoke a row Context Engine? especially when creating DAX formulas that are a built using both Filter and Row Context functions!


Please correct me if i am wrong :)