Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

ROW Function (DAX)


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

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


The name given to the column, enclosed in double quotes.


Any DAX expression that returns a single scalar value to populate. name.

A single row table

Arguments must always come in pairs of name and expression.

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]))

The code is split in two lines for readability purposes

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft