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 10
Advanced DAX: Dynamic Measures and Conditional Logic
1
Capturing Slicer Selections with SELECTEDVALUE
Write a measure using SELECTEDVALUE to capture a user's selection from a slicer
2
Dynamic Measures with SWITCH & SELECTEDVALUE
Create a dynamic measure that changes the calculation it performs based on a user's selection, using SWITCH and SELECTEDVALUE
3
Top N Products by Sales with TOPN and CALCULATE
Write a Top N filtering measure using TOPN combined with CALCULATE to show top products by sales
4
Managing Missing Data with IF, ISBLANK, and COALESCE
Handle blank or missing data gracefully in measures using IF, ISBLANK, and COALESCE
Previous module
Advanced DAX: Variables, Ranking, and Rolling Periods
Next module
Practical Application: Target vs. Actual Analysis