SELECTEDVALUE
Applies to: Calculated column Calculated table Measure Visual calculation
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>)
isIF(HASONEVALUE(<columnName>), VALUES(<columnName>), <alternateResult>)
.To learn more about best practices when using SELECTEDVALUE, see Use SELECTEDVALUE instead of VALUES in DAX.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
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 |