DAX Aggregation - ROW function


Advertisements

Description

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

Syntax

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

Parameters

Sr.No. Parameter & Description
1

name

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

2

expression

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

Return Value

A single row table.

Remarks

Parameters must always come in pairs of name and expression.

Example

= ROW (Total Number of Products, COUNTA (Products, Products[Product_key]),
   Total Sales Value, SUM (Sales, Sales[ExtendedAmount])) 
dax_functions_aggregation.htm

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements