Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
DAX for Power BI Mastery
·
Module 5
Mastering CALCULATE and Filter Modification
Understanding CALCULATE and Filter Context
Explain the purpose of the CALCULATE function and its role in modifying the filter context
2
CALCULATE with Simple Filters
Write a measure using CALCULATE with a simple filter argument (e.g., filtering for a specific product category)
3
Removing Filters with ALL and CALCULATE
Use the ALL function within CALCULATE to remove filters from a table or specific columns
4
Calculating Percentages of Totals with CALCULATE and ALL
Calculate the percentage of a grand total or subtotal using CALCULATE and ALL
5
Mastering ALLEXCEPT for Selective Filter Removal
Use the ALLEXCEPT function to remove all filters from a table except for specified columns
Previous module
Core Theory: Understanding Evaluation Context
Next module
Iterator Functions (X-Functions) and Table Filtering