Back to Roadmap
Level 5 — Real-World DAX Patterns+75 XP
Lesson 3
3. SELECTEDVALUE
Read single slicer selections dynamically in measures and titles.
The Concept
SELECTEDVALUE returns the value of a column when there is only one distinct value in filter context; otherwise returns an alternate result.
Example DAX:
Selected Segment Title =
SELECTEDVALUE(
Customers[Segment],
"All Customer Segments"
)Extremely popular for dynamic chart titles, KPI card subtitles, and dynamic currency converters.
Try It Yourself
Use SELECTEDVALUE on Customers[Country] with fallback 'Global'.
fx
[fx]SELECTEDVALUE=
Loading DAX Formula Studio...
Type [ for fields