Forum Discussion

swolfe2's avatar
swolfe2
Helper I
1 year ago
Solved

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

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

 

 

  • 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?

2 Replies

  • 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's avatar
      swolfe2
      Helper I

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