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:
To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File #49
Example 2: Get selected or multiple values from slicers
In today’s #daxfridays video I will show you how to get selected or multiple values from a slicer:
Download example file:
To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File #118
Example 3: Weekly time intelligence in Power BI
Are you also bummed out that there is no weekly time intelligence in DAX? Believe it or not, creating weekly calculations is easier than you think, and I show you how in this edition of #DAXfridays.
Download example file:
To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File #124
Remarks
An equivalent expression for SELECTEDVALUE(<columnName>, <alternateResult>) is IF(HASONEVALUE(<columnName>), VALUES(<columnName>), <alternateResult>).
Hi Ruth, a fantastic movie. Could you please help look into the total line – looks the total is for the Max ranks and not changing with the changes of selection like Top 3, Top 5, etc. Appreciate your time. Thanks.
Hi, I am unable to download source file for Sum, sumx, and isinScope functions
The file you need to get corresponds to the dax friday’s video number. If you dont find it, then I dont have it, I am afraid.
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