DAX Aggregation - DISTINCTCOUNT function

Description

Counts the distinct values in a column.

Syntax

DISTINCTCOUNT (<column>)

Parameters

Return Value

A whole number.

Remarks

You can use columns containing any type of data. When the function finds no rows to count, it returns a blank.

Example

= DISTINCTCOUNT (Sales[Account])