SELECTEDVALUE DAX Function

The SELECTEDVALUE function returns the value when the context for columnName has been filtered down to one distinct value only, otherwise returns an optional alternateResult if specified.

DAX Syntax SELECTEDVALUE(ColumnName)
Or
SELECTEDVALUE(ColumnName, AlternateResult)

The function has the following parameters:

• ColumnName: The name of an existing column, using standard DAX syntax. It cannot be an expression.
• AlternateResult: (Optional) The value returned when there is either no value or more than one value in the specified column (if omitted, the default value blank is returned).