Microsoft · DP-600
DAX variables, iterators, and filters
DP-600 · Lesson 12 of 15 · 1:16:03
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-600 exam (Microsoft Certified: Fabric Analytics Engineer Associate). In this lesson: variables with VAR and RETURN, iterators like SUMX and RANKX, table filtering with FILTER, ALL, and KEEPFILTERS, and information functions like ISINSCOPE and HASONEVALUE. Includes three original practice questions.
Preview the topics
- The Sales table stores a quantity and a unit price on each row, but no amount column. A measure must return the total revenue. Which expression fits?
- A measure must show each product’s share of total sales, whatever product each row of the visual shows. What should the denominator use?
- In a matrix of categories and products, a ranking must show on product rows, and stay blank on category subtotals. Some categories hold a single product. Which function should test the level?