DAX function

ROW — DAX function reference

Build a single-row table.

Syntax

dax

ROW(<name1>, <expression1> [, <name2>, <expression2>, …])

dax

ROW("Total", SUM(Sales[Amount]))

→ A one-row table

dax

ROW("Total Sales", SUM(Sales[Amount]), "Total Profit", SUM(Sales[Profit]))

→ A one-row, two-column summary table

dax

UNION(
    ROW("Metric", "Actual", "Value", [Total Sales]),
    ROW("Metric", "Target", "Value", [Sales Target])
)

→ Builds a small two-row comparison table from scratch for a chart

ROW always produces exactly one row — to build multiple rows, combine several ROW() calls with UNION, as shown above, rather than trying to pass multiple values into a single ROW.
It's most useful for constructing small ad-hoc tables (DAX queries, what-if scaffolding, debugging intermediate values) — it's rarely used inside a stored measure since measures return scalars, not tables.

From Tables & set operations