Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Dependency Of A Function On Row Context In DAX Explained With DAX Studio

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

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.