Gives back whatever format string belongs to the current measure. Calculation items use it within format string expressions, typically as a fallback when currency formats change dynamically.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains SELECTEDMEASUREFORMATSTRING in context, with comparison tables and the common traps.
Terms in this definition
- FORMAT
A DAX function that turns a value into text according to a format string, for instance "MMMM" to show a month's name. Since the output is text, numeric operations can't use it, and dynamic format strings were introduced to get around that.
- Measure
A figure like total revenue, worked out by aggregating fact table data wherever dimensions intersect within a semantic model.