topic Re: Dynamic Measure Formatting Negative Values with Parentheses Instead of (-) in DAX Commands and Tips

Dynamic Measure Formatting Negative Values with Parentheses Instead of (-)

swolfe2 — Thu, 02 Jan 2025 21:30:37 GMT

I am attempting to do some dynamic measure formatting on a DAX measure. However, I'm having difficulty getting negative values to display with parentheses instead of the negative symbol.

For example, if I have a value of -132,500,000, I want to display it as ($132) M.

The dynamic measure formatting is working great for positive numbers, I'm just unsure how to get it to display correctly with negative values.

VAR CurrentValue = SELECTEDMEASURE() RETURN SWITCH ( TRUE(), CurrentValue <= -1000000, "($#,0,,.) M", CurrentValue > -1000000 && CurrentValue < 0, "($#,##0)", CurrentValue >= 0 && CurrentValue < 1000000, "$#,##0", CurrentValue >= 1000000, "$#,0,,. M" )

Re: Dynamic Measure Formatting Negative Values with Parentheses Instead of (-)

OwenAuger — Thu, 02 Jan 2025 21:53:00 GMT

Hi swolfe2

I would recommend this:

VAR CurrentValue = SELECTEDMEASURE() VAR AbsValue = ABS ( CurrentValue ) RETURN IF ( AbsValue >= 1000000, "$#,0,,. M;($#,0,,.) M", "$#,##0;($#,##0)" )

This makes use of the "<positive format>;<negative format>" structure.

Does this work for you?

Re: Dynamic Measure Formatting Negative Values with Parentheses Instead of (-)

swolfe2 — Thu, 02 Jan 2025 22:02:45 GMT

Worked perfectly, and is an elegant solution. Thanks so much!