MSPTDA 19: CALCULATE DAX Function & Filter Context & ALLSELECTED & KEEPFILTERS (50 Examples)
This course provides an in-depth look at the DAX functions CALCULATE, CALCULATETABLE, ALLSELECTED, and KEEPFILTERS. It covers topics such as Boolean Filters, Overwrite Operator, Context Transition, and Frequency Distribution. It also provides examples of how to use these functions in Excel and Power BI. By the end of the course, participants will have a better understanding of how to use these functions to create powerful data models. ▼
ADVERTISEMENT
Course Feature
Cost:
Free
Provider:
Youtube
Certificate:
Paid Certification
Language:
English
Start Date:
On-Demand
Course Overview
❗The content presented here is sourced directly from Youtube platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.
Updated in [February 21st, 2023]
This course provides an in-depth look at the DAX functions CALCULATE, CALCULATETABLE, ALLSELECTED, and KEEPFILTERS. It covers how to use these functions to change the filter context, perform context transitions, and create grand totals that respect the filtering in the PivotTable. It also covers how to use these functions to solve complex filter reduction errors.
Possible Development Paths include learning more about DAX functions, such as SUMX, AVERAGEX, and MAXX, as well as understanding the concepts of filter context and context transition. Learners can also explore more advanced topics such as time intelligence functions and DAX formula evaluation context.
Learning Suggestions for learners include reading up on the DAX functions mentioned in the course, such as CALCULATE, CALCULATETABLE, ALLSELECTED, and KEEPFILTERS. Learners should also practice using these functions in Power BI and Excel to gain a better understanding of how they work. Additionally, learners should explore related topics such as filter context, context transition, and time intelligence functions.
Course Provider
Provider Youtube's Stats at AZClass
Discussion and Reviews
0.0 (Based on 0 reviews)
Start your review of MSPTDA 19: CALCULATE DAX Function & Filter Context & ALLSELECTED & KEEPFILTERS (50 Examples)