SELECTEDMEASUREFORMATSTRING - DAX Guide

SELECTEDMEASUREFORMATSTRING: Returns format string for the measure that is currently being evaluated.

This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel.


#dax #powerbi #ssas #tabular #analysisservices #powerpivot

[MrGeneralLedger]

I have been thinking for years about how to achieve this same effect. Thank you Alberto.

[LouLouMagou]

Thank you so much, got to love Microsoft Documentation when it comes to functions! :))

[nvtruongmanh]

Is there any way I can use dot as thousand separator and comma as decimal separator?

Like this one:
FORMAT( 1234.567, "#, 0.00", "de-DE" )

Desired result:
1.234, 57

or:
1, 23 K

[noahhadro]

Any chance there is a way to use this on regular measures? For instance, on a measure that uses switch true?

[will]

Can't you achieve this using fields parameter?

[egytal]

I really want to ask why you guys don't do any powerpoint slides or visuals to explain those concepts it is way much easier to understand like this and it helps preventing you Mr.Ferrari from mistakenly say something that you don't want to say or forgot the word for it. Other than this perfect content with Ferrari quality like except for this absence of visuals & slides point.

[SolotaireKid]

Quickly say SELECTEDMEASUREFORMATSTRING 10 times

[brundleseth]

I can't even pronounce the name of the function.