Edit

Share via

ROW function

  • Article

Applies to: Calculated column Calculated table Measure Visual calculation

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

Syntax

DAX 
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.

  • This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Example

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

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