Which DAX function creates a table containing distinct values from a column?

Question

Power BI — Medium

Which DAX function creates a table containing distinct values from a column?

Accepted Answer

The DAX function DISTINCT() creates a table with unique values from a specified column, making it ideal for removing duplicates. This function is specifically designed to return a list of distinct values. In contrast, UNIQUE() returns a table with all unique combinations of values, while VALUES() returns a table with all values. DISTINCT() is the correct choice for retrieving distinct values from a single column.