How Iterator Functions Work in DAX

Added: 2026-05-16

[00:00:00]This is a family of functions that let you define your aggregation level. Think about it as computing at level A before summarizing and aggregating at level B. They're often used in measures most of the time and they loop through a table row by row. And again, because I love examples, let me bring up a way to slice and dice this and look at this a little bit where we can use the sum x function to calculate credits at the cargo level where it will essentially create an internal table internal engine table here that will aggregate that up to produce a final result with this number of rows in here. Can be very useful if the calculation won't calculate correctly if it's non-additive for any reasons due to model complexity. So, you can sum it at this level first before essentially doing a final calculation of adding all these numbers together.

[00:00:46]Similar with an average function.