Row Context is one of the most important concepts in DAX. It refers to the current row being evaluated when a formula is calculated.<\/p>\n\n\n\n
In simple terms, Row Context means DAX is working one row at a time.<\/p>\n\n\n\n
Row Context is automatically created in Calculated Columns and inside iterator functions such as SUMX, AVERAGEX, and FILTER.<\/p>\n\n\n\n
When you create a calculated column, DAX automatically evaluates the formula for each row in the table.<\/p>\n\n\n\n
Profit = Sales[Revenue] - Sales[Cost]<\/pre>\n\n\n\nHere, DAX calculates Revenue minus Cost for each individual row in the Sales table.
Each row has its own result because the formula runs row by row.<\/p>\n\n\n\nThis is Row Context.<\/p>\n\n\n\n
Row Context in Iterator Functions<\/h2>\n\n\n\n
Iterator functions create Row Context manually while looping through a table.<\/p>\n\n\n\n
Example using SUMX<\/h3>\n\n\n\n
Total Revenue = SUMX(Sales, Sales[Quantity] * Sales[Unit Price])<\/pre>\n\n\n\nSUMX goes through each row in the Sales table, multiplies Quantity by Unit Price, and then sums the results.<\/p>\n\n\n\n
Even though this is a Measure, SUMX creates Row Context during calculation.<\/p>\n\n\n\n
Important Difference<\/h2>\n\n\n\n
Calculated Columns always have Row Context.<\/p>\n\n\n\n
Measures do not automatically have Row Context unless an iterator function is used.<\/p>\n\n\n\n
This is why simple column references work in calculated columns but may require aggregation in measures.<\/p>\n\n\n\n
Why Row Context is Important<\/h2>\n\n\n\n
\n
- Helps perform row-by-row calculations<\/li>\n\n\n\n
- Essential for understanding calculated columns<\/li>\n\n\n\n
- Required when using iterator functions<\/li>\n\n\n\n
- Helps avoid common DAX errors<\/li>\n<\/ul>\n\n\n\n
Common Confusion<\/h2>\n\n\n\n
Row Context is different from Filter Context.<\/p>\n\n\n\n
Row Context works on a single row at a time.
Filter Context works on filtered sets of data based on visuals and slicers.<\/p>\n\n\n\nUnderstanding Row Context is the foundation for mastering advanced DAX concepts.<\/p>\n\n\n\n
<\/strong><\/p> <\/div> <\/div>\n\n\n