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
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
To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.