SELECTEDMEASUREFORMATSTRING DAX Function (Information)
Returns format string for the measure that is currently being evaluated.
Syntax
This expression has no parameters.
Return values
Format string of the measure currently being evaluated – which is the measure identified by SELECTEDMEASURE.
Examples
-- Format string expression for Thousands calculation item
-- in Scale calculation group, which is used in the following example:
VAR CurrentFormatString =
SELECTEDMEASUREFORMATSTRING ()
VAR FormatStringContainsDot =
SEARCH ( ".", CurrentFormatString, 1, 0 ) > 0
VAR Result =
CurrentFormatString & IF ( NOT FormatStringContainsDot, ".00" ) & " K"
RETURN
Result
-- SELECTEDMEASUREFORMATSTRING returns the format string of the
-- selected measure. It can be used only in calculation items
--
-- Its main usage is to dynamically create a format string based on
-- the original format string, modified by the calculation item
EVALUATE
SUMMARIZECOLUMNS (
'Date'[Calendar Year],
'Scale'[Scale],
TREATAS ( { "CY 2009" }, 'Date'[Calendar Year] ),
"Amount", [Sales Amount],
"Format String", IGNORE('Sales'[_Sales Amount FormatString] )
)
ORDER BY
'Date'[Calendar Year]
| Calendar Year | Scale | Amount | Format String |
|---|---|---|---|
| 2009-01-01 | Value | 9,353,814.87 | #,0.00 |
| 2009-01-01 | Thousands | 9,353.81 | #,0.00 K |
| 2009-01-01 | Millions | 9.35 | #,0.00 M |
Related articles
Learn more about SELECTEDMEASUREFORMATSTRING in the following articles:
-
Understanding Calculation Groups
This article explores the properties of calculation groups in detail and then it describes how a calculation item is applied to a measure. Before starting, we suggest you read the previous article that introduces calculation groups. » Read more
-
Currency conversion in Power BI reports
This article describes how to implement currency conversion for reporting purposes in Power BI. » Read more
-
Controlling Format Strings in Calculation Groups
This article describes how to control format strings in calculation groups. Before starting, we suggest you read the previous articles in this series. » Read more
Last update: Sep 14, 2023 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/selectedmeasureformatstring-function-dax