DAX Function Guide

SELECTEDMEASURE
Empty image or helper icon

Sam McKay

CEO & Founder

How does the SELECTEDMEASURE 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?

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

Related Blog Posts

Loading

Considerations when using the SELECTEDMEASURE?

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

Loading

Formula examples using the SELECTEDMEASURE

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

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

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

Related Courses

Loading