Edit

Share via

ISSELECTEDMEASURE

  • Article

Applies to: Calculated column Calculated table Measure Visual calculation

Used by expressions for calculation items to determine the measure that is in context is one of those specified in a list of measures.

Syntax

ISSELECTEDMEASURE( M1, M2, ... )

Parameters

Term Definition
M1, M2, ... A list of measures.

Return value

A Boolean indicating whether the measure that is currently in context is one of those specified in the list of parameters.

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 checks if the current measure is one of those specified in the list of parameters. If the measures are renamed, formula fixup will reflect the name changes in the expression.

IF (
    ISSELECTEDMEASURE ( [Expense Ratio 1], [Expense Ratio 2] ),
    SELECTEDMEASURE (),
    DIVIDE ( SELECTEDMEASURE (), COUNTROWS ( DimDate ) )
)

Related content

SELECTEDMEASURE
SELECTEDMEASURENAME