DAX Function Guide
DISTINCT (table)
Sam McKay
CEO & Founder
How does the DISTINCT (table) work?
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