row-function-dax.md

description	title
Learn more about: ROW function	ROW function (DAX) | Microsoft Docs

ROW function

[!INCLUDEapplies-to-measures-columns-tables-visual-calculations]

Returns a table with a single row containing values that result from the expressions given to each column.

Syntax

ROW(<name>, <expression>[[,<name>, <expression>]…])  

Parameters

Term	Definition
name	The name given to the column, enclosed in double quotes.
expression	Any DAX expression that returns a single scalar value to populate. name.

Return value

A single row table

Remarks

• Arguments must always come in pairs of name and expression.

• [!INCLUDE function-not-supported-in-directquery-mode]

Example

The following example returns a single row table with the total sales for internet and resellers channels.

ROW("Internet Total Sales (USD)", SUM(InternetSales_USD[SalesAmount_USD]),  
         "Resellers Total Sales (USD)", SUM(ResellerSales_USD[SalesAmount_USD]))