SELECTEDMEASUREFORMATSTRING

Updated on
Rick de Groot

SELECTEDMEASUREFORMATSTRING is a DAX function that returns the format string for the measure currently being evaluated.

Syntax

SELECTEDMEASUREFORMATSTRING( )

Return Values

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() )

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/selectedmeasureformatstring-function-dax

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy