Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
DISTINCTCOUNT Function

DISTINCTCOUNT Function (DAX)

 

The DISTINCTCOUNT function counts the number of different cells in a column of numbers.

DISTINCTCOUNT(<column>)

column

The column that contains the numbers to be counted

The number of distinct values in column.

The only argument allowed to this function is a column. You can use columns containing any type of data. When the function finds no rows to count, it returns a BLANK, otherwise it returns the count of distinct values.

The following example shows how to count the number of distinct sales orders in the column ResellerSales_USD[SalesOrderNumber].

=DISTINCTCOUNT(ResellerSales_USD[SalesOrderNumber])

Using the above measure in a table with calendar year in the side and product category on top gives the following results:

Distinct Reseller Orders count

Column Labels

Row Labels

Accessories

Bikes

Clothing

Components

Grand Total

2005

135

345

242

205

366

2006

356

850

644

702

1015

2007

531

1234

963

1138

1521

2008

293

724

561

601

894

1

1

Grand Total

1315

3153

2410

2646

1

3797

In the above example the user should be able to note that the rows Grand Total numbers do not add up, this happens because the same order might contain line items, in the same order, from different product categories.

Community Additions

ADD
Show:
© 2015 Microsoft