How does the ISSELECTEDMEASURE function (DAX) work?

ISSELECTEDMEASURE function (DAX) is used by expressions for calculation items, one of those specified in a list of measures is to determine the measure in context.

ISSELECTEDMEASURE Formula Syntax

ISSELECTEDMEASURE (M1, M2, … )

How do you use the ISSELECTEDMEASURE function?

This function returns true if one of the specified measures is currently being evaluated.

Related Blog Posts

 

Considerations when using the ISSELECTEDMEASURE function

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

This function currently applies only to SQL Server 2019 Analysis Services CTP 2.3 and later.

Related Video Tutorials

Formula examples using the ISSELECTEDMEASURE function

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

Related DAX Functions

Related Course Modules