Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
SELECTEDMEASURE
Applies to: 👁 Image
Calculated column 👁 Image
Calculated table 👁 Image
Measure 👁 Image
Visual calculation
Used by expressions for calculation items or dynamic format strings 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 or format string is evaluated.
Remarks
Can only be referenced in the expression for a calculation item or format string.
-
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]))
The following expression can be used to dynamically adjust the format string of a measure based upon whether a value is the hundreds, thousands, or millions.
SWITCH(
TRUE(),
SELECTEDMEASURE() < 1000,"$#,##0", //Values less than 1000 have no text after them
SELECTEDMEASURE() < 1000000, "$#,##0,.0 K", //Values between 1000 and 1000000 are formatted as #.## K
"$#,##0,,.0 M" //Values greater than 1000000 are formatted as #.## M
)
Related content
Feedback
Was this page helpful?