← Lesson 8All Courses

DAX in Power BI for Data Science & Analytics

Understanding Row Context

Stop memorizing the phrase “row context.” Step through actual sales rows, predict what DAX sees, build row-level calculations, debug them, and understand why row context is one of the most important ideas in DAX.

8

Interactive Investigations

5

Real Sales Rows

ROW

Context Laboratory

The Mental Model

1

Current Row

Order 103

2

Values

5 × ₹2,500

3

Expression

Quantity × Price

4

Result

₹12,500

Concepts: 0 of 8 completed

0%

CONCEPT 1 OF 8

What Row Context Actually Means

Row context means DAX is evaluating an expression from the perspective of one current row. This idea is fundamental when working with calculated columns and row-by-row calculations.

Row Context = Current RowProductQuantityPriceDAXKeyboard5₹2,500Current RowQuantity × Price = row-level calculation

Imagine DAX standing inside one row

Consider a sales table. It contains many orders. When a calculated column is evaluated, DAX processes the table row by row.

For the current row, DAX can directly evaluate column values belonging to that row.

Order = 103

Quantity = 5

Price = ₹2,500

Quantity * Price = row-level calculation

Think like the engine

“I am currently evaluating one particular row. What are the Quantity and Price values in that row?”

Which concept describes this current-row perspective?

Understanding Row Context in DAX

Row context is one of the foundational concepts in DAX for Power BI. It describes the current row being evaluated by an expression. Understanding row context helps analysts reason about calculated columns and row-level calculations.

What Is Row Context in DAX?

Row context means that DAX evaluates an expression from the perspective of a particular current row. When a calculated column performs a row-level calculation, column references can represent values from that current row.

Row Context Example

Suppose a sales table contains Quantity and Price. A row-level revenue calculation can multiply Quantity by Price for each order. This makes row-level reasoning useful for understanding calculated columns.

Row Context vs Filter Context

Row context and filter context are different DAX concepts. Row context describes the current row being evaluated, while filter context determines which data is considered by a calculation. Understanding this distinction is essential before learning CALCULATE and more advanced DAX patterns.

Calculated Columns and Row Context

Calculated columns are evaluated for rows in a table. This makes row-by-row calculations a useful way to understand the practical meaning of row context.

What You Learn in This Lesson

  • • Meaning of row context in DAX
  • • Current-row evaluation
  • • Column references in row context
  • • Row-by-row calculations
  • • Calculated columns
  • • Row context vs filter context
  • • Measures and evaluation behavior
  • • Debugging row-level DAX