How does the SELECTEDMEASURE function (DAX) work?

There is a proliferation of measures in complex Power BI data models, resulting in poor user experience where an analyst will need to sift through so many measures. Calculation groups are used to reduce the number of measures and present a cleaner, uncluttered user interface. The SELECTEDMEASURE function (DAX) is a type of calculation group. It is used for calculation items using expressions to reference the measure in context.

SELECTEDMEASURE Formula Syntax

SELECTEDMEASURE(
)

How do you use the SELECTEDMEASURE function?

The SELECTEDMEASURE function is often used in calculation items. It returns the measure that is currently being evaluated.

Related Blog Posts

 

Considerations when using the SELECTEDMEASURE function

SELECTEDMEASURE references the measure that is currently in the context of the assessment of the calculation item. This expression has no parameters and can only be referenced for the calculation item that is being evaluated.

Related Video Tutorials

Formula examples using the SELECTEDMEASURE function (DAX)

CALCULATE(
    SELECTEDMEASURE( ),    
    DATESYTD( DimDate [Date] )
)

CALCULATE(
    SELECTEDMEASURE( ),
    SAMEPERIODLASTYEAR( ‘Date'[Date])
)

Related DAX Functions

Related Course Modules