Power BI · Chapter 46
DAX: Iterators, Table Functions and Virtual Tables
SUM vs SUMX, FILTER, shaping virtual tables, and keeping grain small — with clear VAR.
Fictional sample data for learning. Brands belong to their owners. Numbers are made up for class.
In this chapter
- Choose SUM vs SUMX with a reason.
- Build a filtered virtual table with FILTER.
- Shape columns with ADDCOLUMNS / SELECTCOLUMNS.
- Summarise with SUMMARIZE carefully.
- Keep virtual tables readable and small.
- Explain iterators in an interview.