VALUES

VALUES When the input parameter is a column name, returns a one-column table that contains the distinct values from the specified column. Duplicate values are removed and only unique values are returned. A BLANK value can be added. When the input parameter is a table name, returns the rows from the specified table. Duplicate rows are preserved. A BLANK row can be added.


Syntax

VALUES(TableNameOrColumnName)

Parameters

TableName or Column Name – A column from which unique values are to be returned, or a table from which rows are to be returned.

Return Value

When the input parameter is a column name, a single column table. When the input parameter is a table name, a table of the same columns is returned.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Filter Functions / VALUES