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 6
Iterator Functions (X-Functions) and Table Filtering
Iterator Functions and Row Context in DAX
Explain how iterator functions (e.g., SUMX) differ from simple aggregations by creating a row context
2
Row-Level Calculations with SUMX and AVERAGEX
Write measures using SUMX and AVERAGEX to perform row-level calculations, such as calculating total revenue (Price * Quantity)
3
Mastering Weighted Averages with SUMX
Calculate weighted averages using SUMX
4
Advanced Filtering with FILTER and CALCULATE
Use the FILTER function to create complex, table-based filtering conditions within CALCULATE
Previous module
Mastering CALCULATE and Filter Modification
Next module
Time Intelligence: Building a Date Table