Menu
CoddyTech
Start learning

AVERAGEX and MAXX

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

AVERAGEX, MINX and MAXX work out an expression per row, then average it or keep the smallest or largest.

Biggest Line = MAXX(Sales, Sales[Quantity] * Sales[UnitPrice])

MAX times MAX can mix two different lines; MAXX looks at each line whole.

challenge icon

Challenge

What is the most valuable order line each shop has rung up? Write Biggest Line: the largest quantity times unit price of any line. It is checked for each store.

bugsy Main icon

Start this challenge with Coddy's AI tutor

What is Bugsy?

All lessons in DAX with CALCULATE

1Changing the Filters

Meet CALCULATEA Filter Replaces a FilterSeveral Filters at OnceKeeping FiltersRecap - Member Drink Sales

4DAX You Can Read

Variables with VARChoosing with SWITCHSWITCH(TRUE()) for RangesOne Value or ManyRows or the TotalChecking Copilot's DAXRecap - Sales by Price Band

2Removing Filters

ALL Removes FiltersPercent of TotalRemoving One FilterKeep One Filter: ALLEXCEPTShare of What Is ShownRecap - Store Share in 2025

3Row by Row in a Measure

SUMX Works Row by RowAVERAGEX and MAXXFILTER Picks RowsMeasures Inside IteratorsRanking with RANKXRecap - Profit Without Columns