DAX - Basics Of Filter Context and Calculate

In this video, learn why measures in your visuals dynamically changed base on filter context. Filter context can come from within a visual, from another visual, or from your filters pane. The filter context will always depend upon the data model you are building your report over. After understanding filter context, learn how to manipulate it using the DAX function CALCULATE.
If you enjoy this video and are interested in formal training on DAX, Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Matt20" at check out when purchasing our On-Demand Learning classes from pragmaticworks...
#PragmaticWorks #MatthewPeterson
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning Courses Free Trial: www.pragmaticw...
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks...
🔗Pragmatic Works Boot Camps: pragmaticworks...
🔗Pragmatic Works Hackathons: pragmaticworks...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks...
🔗Pragmatic Works Blog: blog.pragmaticw...

Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️CZcams: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]

[@johnabram4159]

I really appreciate Pragmatic Works. You guys provide high quality lessons.

[@PragmaticWorks]

Thank you! Glad you enjoy them.

[@BestICan]

Very clear explanation. Well done.

[@karahsekir5494]

Best explanation on filter context by far!

[@stevefox7469]

Perhaps the best explanation of filter context and the CALCULATE function I have seen. I do wonder if you should have touched on the concept of "filter columns , not tables" as this is a major cause performance issue when using CALCULATE.

[@martyc5674]

We’ll explained good video 👍

[@yashison]

Very well. Explained. Can we please have a video on conditional formatting bases on text value?

[@prathibhamathews4053]

In what selection context will the last two columns will have different values ?

[@arkangelMX2009]

you rock!

[@tubeitz]

Brilliant!

[@Max-wo7zp]

Your tutorials are very helpful, but it would be really great if you attached pbix or excel file.

[@Ilya_4276]

thanks, it was quite impression Dax function

[@madroneroc]

Your channel is one great resource. Please help - I have a report for Shipped Qty and Billed Qty. I want to add a column that will show the text "Shipped not Billed" for the items that are shipped but not billed. What would be the best measure for this? Thanks in advance!

[@ashleywilkins9644]

Any chance we can a similar lesson using medical data? I constantly get duplicated lines when seeking the last visit date using specific medical codes. End result is the last date per facility, clinician or insurance where I actually want the last date regardless of where, who or what carrier was used. All help is appreciated!

[@azizquazi]

Hi, Can we get the dataset used in this tutorial? Thanks.

[@peterbogdanovich4043]

Sir, Where is this video did you explain the basics of filter context may I ask? I suggest to change the title to something like “All(), Allexcept() Allselected().

[@TheAlgebraTeacherPOWERStoBI]

Hi Peter. My goal was to explain the basics of filter context in regards to active relationships between tables and how those will dynamically change your measure values. Thank you for the feedback.