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