DAX FunctionsWhich DAX function category includes functions that work row-by-row on a table?Scalar functionsIterator functionsTable functionsFilter functions

Break Down the Problem

1. Identify the categories of DAX functions mentioned in the question: Scalar functions, Iterator functions, Table functions, and Filter functions.
2. Analyze which category is pertinent to working row-by-row on a table.

Relevant Concepts

• Scalar Functions: These functions operate on a single value and return a single value (e.g., SUM, AVERAGE).
• Iterator Functions: These functions operate on tables and iterate over rows, applying a specified operation to each row (e.g., SUMX, AVERAGEX).
• Table Functions: These functions return a table and may generate a table from a filter or a calculation (e.g., FILTER, ALL).
• Filter Functions: These are a subset of table functions that apply a filter to a table but do not necessarily imply iterating row-by-row.

Analysis and Detail

1. Scalar functions do not operate row-by-row on tables; they deal with single values.
2. Table functions return tables but do not execute row-wise calculations directly.
3. Filter functions establish conditions but do not inherently do row-wise calculations.
4. Iterator functions specifically apply operations to each row, performing calculations based on the values within individual rows.

Verify and Summarize

Out of the function categories specified, Iterator functions are the ones designed to work row-by-row on a table.

Final Answer

Iterator functions are the DAX function category that includes functions that work row-by-row on a table.