To apply logic-based DAX formatting to a single measure with minimal administrative effort and without modifying other measures, which approach should you use?

To apply logic-based DAX formatting to a single measure with minimal administrative effort and without modifying other measures, which approach should you use?

• A. Calculation group measure formatting
• B. Conditional formatting
• C. Dynamic measure formatting
• D. Fields parameter

Answer: (C)

Dynamic measure formatting lets a single measure control how its value is displayed by using a dynamic format string, often driven by SELECTEDMEASURE. This means you encode the formatting logic inside the measure itself, so the value can appear as currency, percentage, or a custom format depending on what’s being shown in the visual. You don’t touch other measures, and you don’t need to create calculation groups or set up multiple conditional rules across visuals. It keeps the formatting logic localized to one measure, achieving the goal with minimal administrative effort. Other approaches either apply formatting across multiple measures (which adds overhead) or focus on things other than numeric display (like color-based conditional formatting) or on switching which fields are used rather than how they are formatted. Dynamic measure formatting directly targets formatting for the specific measure in use, which is why it’s the best fit here.

Dynamic measure formatting lets a single measure control how its value is displayed by using a dynamic format string, often driven by SELECTEDMEASURE. This means you encode the formatting logic inside the measure itself, so the value can appear as currency, percentage, or a custom format depending on what’s being shown in the visual. You don’t touch other measures, and you don’t need to create calculation groups or set up multiple conditional rules across visuals. It keeps the formatting logic localized to one measure, achieving the goal with minimal administrative effort.

Other approaches either apply formatting across multiple measures (which adds overhead) or focus on things other than numeric display (like color-based conditional formatting) or on switching which fields are used rather than how they are formatted. Dynamic measure formatting directly targets formatting for the specific measure in use, which is why it’s the best fit here.