SELECTEDMEASUREFORMATSTRING
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.
SELECTEDMEASUREFORMATSTRING()
None
A string holding the format string of the measure that is currently in context when the calculation item is evaluated.
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.
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() )