ROW
A table of one row, each column a name and an expression.
Group: Table manipulation. Compatible with DAX.
Syntax
ROW ( <name>, <expression> [, <name>, <expression>] … )| Parameter | Type | Description |
|---|---|---|
name | Text repeatable | A column's name, in quotes. |
expression | Expression repeatable | What the column holds: anything that works out to one value. |
Returns
Table. A table of one row, with a column for each name.
Remarks
- Each expression is evaluated once, in the filter context where ROW stands: a measure gives its value there.
- An expression must give one value. A table with several rows is an error;
CONCATENATEXorCOUNTROWSturn one into a value. - Each column takes the type of its value.
- It is the simplest way to see a few values side by side in a query, as most examples on these pages do.
Examples
A few values side by side
EVALUATE
ROW ( "Product", "Pils", "Liters", 120, "Price", 38.5, "Revenue", 120 * 38.5 )| Product | Liters | Price | Revenue |
|---|---|---|---|
| Pils | 120 | 38.5 | 4620 |
Measures in a row
EVALUATE
ROW (
"Products", COUNTROWS ( Products ),
"Liters sold", [Liters sold],
"Pils", CALCULATE ( [Liters sold], Products[Product] = "Pils" )
)| Products | Liters sold | Pils |
|---|---|---|
| 4 | 1806463 | 1004326 |