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

[swolfe2]

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"
    )

[OwenAuger · Accepted solution]

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?

[swolfe2]

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