DAX Function Guide

DISTINCT (table)
Empty image or helper icon

Sam McKay

CEO & Founder

How does the DISTINCT (table) work?
The DISTINCT (table) function (DAX) returns a table by removing duplicate rows from another table or expression.
DISTINCT (table) Formula Syntax

DISTINCT(
     <table>
)

How do you use the DISTINCT (table)?

The DISTINCT (table) is used to removed the duplicate rows from the table.

Related Blog Posts

Loading

Considerations when using the DISTINCT (table)?

If the parameter is a single table, the result of DISTINCT is affected by the current filter context. In this case it is important to understand the differences with VALUES, which might add an additional blank row in certain conditions.
If the parameter is a table expression, DISTINCT returns a table by removing duplicate rows provided by the table expression.

Related Video Tutorials

Loading

Formula examples using the DISTINCT (table)

EVALUATE DISTINCT( { (1, “A”), (2, “B”), (1, “A”) } )

DISTINCT = COUNTROWS(DISTINCT((Items[ItemName])))

=COUNTROWS(DISTINCT(‘ResellerSales_USD'[ProductKey]))

Related Courses

Loading