Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Fabric, AI, and SQL, Power BI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
ROW(<name>, <expression>[[,<name>, <expression>]…])
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 . |
A single row table
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.
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]))
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Fabric, AI, and SQL, Power BI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount.
Register today