A report author uses SELECTEDVALUE() in a DAX measure. What does this function return when multiple values are selected in a slicer for that column?

Question

Power BI — Hard

A report author uses SELECTEDVALUE() in a DAX measure. What does this function return when multiple values are selected in a slicer for that column?

Accepted Answer

The SELECTEDVALUE() function in DAX returns a single value when used in a measure. However, when multiple values are selected in a slicer, it returns BLANK() or an alternate result. This behavior occurs because the function is designed to handle single selections. Multiple selections put the measure in an ambiguous state.