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.
Example 2:
In today’s #daxfridays video I will show you how to get selected or multiple values from a slicer:
Download example file:
Download Power BI file: here.
Remarks
An equivalent expression for SELECTEDVALUE(<columnName>, <alternateResult>)
is IF(HASONEVALUE(<columnName>), VALUES(<columnName>), <alternateResult>)
.
Was this helpful?
Hi ruth, can you show how to show comma separated values in card upon multiple selection i.e. – A, B
I can’t download the examples file
Please, help
All files have moved to the download center, please download it from there.
/Ruth