DAX Filter Context Basics [Full Course]

After you finish this course:
Student files

During this session, Mitchell will provide an in-depth overview of the concept of filter context in the context of DAX (Data Analysis Expressions). The discussion will delve into the ways in which filter context impacts the authoring of DAX measures, including how it can affect the behavior and results of measures. Furthermore, Mitchell will explain how advanced measures can be created by overriding or modifying the default filter context in order to achieve more sophisticated and precise calculations. This session promises to provide valuable insights and techniques for mastering the nuances of filter context in DAX,  empowering attendees to create powerful and flexible measures in their analysis of data.

Next event:
Intergalactic Learn With The Nerds Day

Next step on your journey:



Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]

#PowerBI #DAX #PragmaticWorks #DevinKnight #Training #Microsoft#Tech #FreeConference #LearnWithTheNerds

**Any sales mentioned in the video may no longer be valid. Offers are subject to change with/without notice and are for a limited time only.

[osPA]

Your breakdown of the difference between SAMEPERIODLASTYEAR and PREVIOUSYEAR is the stuff of LEGENDS!!!! There is no emoticon to express my gratitude for that but I will just say...THANK

[chiraggarg]

Hey everyone, greetings from the digital cosmos! It's fascinating to see such a diverse array of locations represented here. Whether you're waving hello from the tranquil Lake of the Ozarks or bustling Munich, soaking in the sunny vibes of Florida or the cultural richness of Ethiopia, every greeting adds a unique color to our digital tapestry. Let's make this session an engaging journey together, learning and growing from each other's perspectives.

[jayxpea]

this explains so many issues ive experienced. Absolutely ripper of a video. Thanks so much

[worldimpress]

I didnt manage to join yesterday and I regret it. because I really love to watch your hands-on courses, and you are a really great teacher because I can hear that you love it! Great explanations with power (bi :D), I mean energy. Thank you! I stay tuned for the outcoming :)

[doriginal]

That Same period last year thing happened to me and now I finally understand it. Thanks.

[betsegawlemmaamersho]

Thanks Michell and Pragmatic Works Team

[optimistprime]

Very informative. Thank you so much.

[tikummacmillianngu]

Hello sir, Thanks very much for your strategic aspects in DAX. I really enjoy it. Please, can you do a session on how to get the values of the previous week of the same year? Thanks sir.

[PMGRlajhi]

Thank you, it was great, as always. Maybe a bit more nerdish than usually 😁

[osoriomatucurane]

Absolutely sensational tutorial on filter evaluation context. I am at earlier stage of my power bi journey and I am glad to have found the stuning tutorials on the daunting DAX and evaluation context by Michell Petersen. Now, on creating Total US Sales measure, mint 24:17, using calculate(), Mr Business Enginner, " is suggesting using the Sum×() instead, in creating table" . Where does this fit in? Could you kindly write the equivalent expression showing how it works and produce the same results?

[varunbhatia]

Thanks for this session as it was really helpful… just to get along can you pls share the download link for the files.

[Milabdi]

Why do we need to use Dax instead, we can do some steps in the power query steps very easily?! I can't understand the utility of Dax. Could you please explain it to me

[myexcelacademy]

Would like to see a video on Expanded tables please

[thefamousdjx]

Seems to me the total row issue with YTD is a bug in powerbi. I think it’s reasonable that this is confusing because it is poor implementation

[timarrington]

Great class on Filter context.

Is there a way to get a completion certificate, some kind of acknowledgement of attendance?