DAX Context Demystified, Part 4: Iterator Functions and When Row Context Returns
SUMX, AVERAGEX, MAXX — these functions bring row context back into a measure, which sounds helpful until they don't behave the way you expect inside a CALCULATE. Part 4 closes the series with the p…