DAX HANDBOOK
3. Iterative functions
Iterative functions have one special ability, and that is to form a “Virtual” row context for the table supplied as an argument. Table vs Scalar Iterative Functions The most used iterative functions are: SUMX, MINX, MAXX, AVERAGEX, CONCATENATEX, COUNTX, RANKX Pretty much any function ending with X All those functions have 2 things in common, …