ISSELECTEDMEASURE
In a calculation item, whether the measure in context is one of those named.
Group: Information. Compatible with DAX.
Syntax
ISSELECTEDMEASURE ( <measure1> [, <measure2>] … )| Parameter | Type | Description |
|---|---|---|
measure1 | Measure | A measure reference, such as [Revenue]. |
measure2 | Measure optional, repeatable | More measure references; it is enough that one of them is the measure in context. |
Returns
Boolean. TRUE when the measure the calculation item is applied to is one of those named.
Remarks
- It lets an item treat some measures differently:
IF ( ISSELECTEDMEASURE ( [Revenue] ), SELECTEDMEASURE () / 1000, SELECTEDMEASURE () )shows revenue in thousands and leaves the other measures alone. - The arguments are measures themselves, not their names as text.
- Outside a calculation item's expression the call is an error.
Examples
Outside a calculation item
The Example Brewery has no calculation group, and a query cannot define one; outside a calculation item the call has nothing to refer to, and is an error.
EVALUATE
ROW ( "Is it Liters sold", ISSELECTEDMEASURE ( [Liters sold] ) )Result: an error.
Related functions
SELECTEDMEASURE, SELECTEDMEASURENAME, SELECTEDMEASUREFORMATSTRING, IF.