SELECTEDVALUE

Returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult.

Syntax

SELECTEDVALUE(<columnName>[, <alternateResult>])  

Parameters

Term Definition
columnName The name of an existing column, using standard DAX syntax. It cannot be an expression.
alternateResult (Optional) The value returned when the context for columnName has been filtered down to zero or more than one distinct value. When not provided, the default value is BLANK().

Return value

The value when the context for columnName has been filtered down to one distinct value only. Else, alternateResult.

Remarks

An equivalent expression for SELECTEDVALUE(<columnName>, <alternateResult>) is IF(HASONEVALUE(<columnName>), VALUES(<columnName>), <alternateResult>).

Example

The following DAX query:

DEFINE MEASURE DimProduct[Selected Color] = SELECTEDVALUE(DimProduct[Color], "No Single Selection")
EVALUATE SUMMARIZECOLUMNS(ROLLUPADDISSUBTOTAL(DimProduct[Color], "Is Total"), "Selected Color", [Selected Color])
ORDER BY [Is Total] ASC, [Color] ASC

Returns the following:

DimProduct[Color] [Is Total] [Selected Color]
Black FALSE Black
Blue FALSE Blue
Grey FALSE Grey
Multi FALSE Multi
NA FALSE NA
Red FALSE Red
Silver FALSE Silver
Silver/Black FALSE Silver/Black
White FALSE White
Yellow FALSE Yellow
TRUE No Single Selection