ROW is a DAX function that returns a single-row table with new columns defined by specified DAX expressions.
ROW(
[ Name, ... ],
[ Expression, ... ]
)| Argument | Properties | Description |
|---|---|---|
| Name | Repeatable | Name of the new column. |
| Expression | Repeatable | The expression for the column. |
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]))
Other functions related to ROW are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy