Edit

SELECTEDMEASURE

  • Article
  • 2 minutes to read

Used by expressions for calculation items to reference the measure that is in context.

Syntax

SELECTEDMEASURE()

Parameters

None

Return value

A reference to the measure that is currently in context when the calculation item is evaluated.

Remarks

  • Can only be referenced in the expression for a calculation item.

  • This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Example

The following calculation item expression calculates the year-to-date for whatever the measure is in context.

CALCULATE(SELECTEDMEASURE(), DATESYTD(DimDate[Date]))

See also

SELECTEDMEASURENAME
ISSELECTEDMEASURE