HASONEVALUE DAX Function (Information)
Returns true when there’s only one value in the specified column.
Syntax
HASONEVALUE ( <ColumnName> )
| Parameter | Attributes | Description |
|---|---|---|
| ColumnName |
The column to check the filter info. |
Return values
Scalar A single boolean value.
TRUE when the context for ColumnName has been filtered down to one distinct value only. Otherwise is FALSE.
Remarks
HASONEVALUE corresponds to the following code:
COUNTROWS ( VALUES ( <ColumnName> ) ) = 1
Related functions
Other related functions are:
Last update: Aug 7, 2020 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/hasonevalue-function-dax