ISSELECTEDMEASURE Function (DAX)

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

Related Support Forum Posts

Accessing Matrix hierarchy levels
Dynamic RANKX with Other Category
Developing Complex Dax functions

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

Dynamically-Compare-Monthly-Information-Cumulatively-in-Power-BI-w-DAX-1

Formula examples using the ISSELECTEDMEASURE function

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

Related DAX Functions

SELECTEDMEASURE Function (DAX)
SELECTEDMEASURENAME
ROUNDUP

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership