ISSELECTEDMEASURE - Daxplained

ISSELECTEDMEASURE is a DAX function that returns TRUE if one of the specified measures is currently being evaluated.

Syntax

ISSELECTEDMEASURE( [ Measure, ... ] )

Argument	Properties	Description
Measure	Repeatable	Measure,…

Return Values

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 ) )
)

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/isselectedmeasure-function-dax