Edit

Share via

SELECTEDMEASUREFORMATSTRING

  • Article

Applies to: Calculated column Calculated table Measure Visual calculation

Used by expressions for calculation items to retrieve the format string of the measure that is in context.

Syntax

SELECTEDMEASUREFORMATSTRING()

Parameters

None

Return value

A string holding the format string of the measure that is currently in context when the calculation item is evaluated.

Remarks

  • This function can only be referenced in expressions for calculation items in calculation groups. It is designed to be used by the Format String Expression property of calculation items.

  • This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Example

The following expression is evaluated by the Format String Expression property for a calculation item. If there is a single currency in filter context, the format string is retrieved from the DimCurrency[FormatString] column; otherwise the format string of the measure in context is used.

SELECTEDVALUE( DimCurrency[FormatString], SELECTEDMEASUREFORMATSTRING() )

Related content

SELECTEDMEASURE ISSELECTEDMEASURE