DAX function
SELECTEDVALUE — DAX function reference
The single value in context.
Syntax
dax
SELECTEDVALUE(<column>, [<alternateResult>])
Examples
dax
SELECTEDVALUE(Sales[Region], "All regions")
→ A value
dax
"Report for: " & SELECTEDVALUE('Date'[MonthName], "multiple months")→ A dynamic title that reads the current slicer selection
Pairs SELECTEDVALUE with a disconnected parameter table to let users pick which measure a chart shows.
dax
SWITCH(SELECTEDVALUE('Metric Selector'[Metric]), "Sales", [Total Sales], "Profit", [Total Profit], BLANK())→ A disconnected-table "metric switcher" pattern
Common mistakes & gotchas
- Returns the fallback when zero or many values are in context. Cleaner than HASONEVALUE plus VALUES.
- SELECTEDVALUE is syntactic sugar for IF(HASONEVALUE(column), VALUES(column), alternateResult) — it still evaluates in whatever filter context it’s called from, so wrapping it in CALCULATE with a different filter changes what "selected" means.
- The alternate-result argument defaults to BLANK() if omitted, which can silently blank out a visual when more than one value is in context — always pass an explicit fallback for titles or labels.
Related DAX functions
From Filter context