VALUES DAX Function in Power BI

In the VALUES dax function, 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 a table object with the same columns that contain the rows from the specified table. Duplicate rows are preserved. A BLANK row can be added.

DAX Syntax VALUES(TableNameOrColumnName)

The parameter is a column from which unique values are to be returned, or a table from which rows are to be returned.

Note This function cannot be used to Return values into a cell or column on a worksheet; rather, we use it as an intermediate function, nested in a formula, to get a list of distinct values that can be counted or used to filter or sum other values.

Example: Let’s we have the following table named Countries.

VALUES dax function in Power BI

Let’s create a calculated table, with the following dax formula.

DAX

VALUES Table = VALUES(Countries[Country])

The output of the above code is shown in the image below:

VALUES dax function in Power BI