In this tutorial, we’re going to take a look at a piece of DAX code that you might have written in your DAX journey. You might also have been confused as to how this code is actually working, and how both Row Context and Filter Context seem to be interacting with each other in just a single DAX code.

Antriksh

***** Video Details *****
00:00 Introduction
0:59 Data model
01:33 Running total measure
03:06 ALL function
04:44 MAX function
05:53 Creating variables
07:39 2 evaluation contexts
08:39 Iteration scenario
10:10 Calculated table
11:40 MAX Year measure
13:09 DAX studio
13:22 Query measure
14:58 Logical query plan of original code
18:44 Logical query plan of variable version

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #RowContext #FilterContext