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>).
[Total: 2 Average: 5/5]
« Back to Index
Let us know your thoughts...