As DAX is built around dealing with tables, aggregating single columns of table data is incredibly easy. All standard aggregation functions, such as SUM, AVERAGE, MAX, and MIN, take a column as input as well as their corresponding iterative aggregation functions, such as SUMX, AVERAGEX, MAXX, and MINX. However, sometimes performing aggregations against a single column is not enough. Sometimes we need to aggregate against multiple columns at the same time.
This recipe demonstrates how to perform aggregations across multiple columns simultaneously.