SELECTEDVALUE

Syntax

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

Tutorial with example

In today’s video, we will go through the DAX function SELECTEDVALUE. SELECTEDVALUE is syntax sugar for IF(HASONEVALUE(VALUES))

Link to Northwind dataset: https://www.youtube.com/watch?v=k3NMI…

Download example file:

The file is available for download here.

Remarks

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