Measures Inside Iterators

Part of the DAX with CALCULATE section of Coddy's Power BI journey. Lesson 15 of 24.

VALUES(Table[Column]) is a table of the different values in the bar.

Inside an iterator, a measure is calculated for the current row: context transition.

Average per Customer = AVERAGEX(VALUES(Sales[CustomerID]), [Revenue])

A bare SUM ignores the row; the measure does not.

Challenge

How much does a customer spend at each shop? Write Average per Customer: the average of Revenue over the different customers. It is checked for each store.

Start this challenge with Coddy's AI tutor

What is Bugsy?

All lessons in DAX with CALCULATE

1Changing the Filters

Meet CALCULATE A Filter Replaces a Filter Several Filters at Once Keeping Filters Recap - Member Drink Sales

4DAX You Can Read

Variables with VAR Choosing with SWITCH SWITCH(TRUE()) for Ranges One Value or Many Rows or the Total Checking Copilot's DAX Recap - Sales by Price Band

2Removing Filters

ALL Removes Filters Percent of Total Removing One Filter Keep One Filter: ALLEXCEPT Share of What Is Shown Recap - Store Share in 2025

3Row by Row in a Measure

SUMX Works Row by Row AVERAGEX and MAXX FILTER Picks RowsMeasures Inside IteratorsRanking with RANKX Recap - Profit Without Columns