Need to show values within range to one decimal point and those outside range no decimal

[Anonymous]

I'm having problems with a DAX measure, I need the displayed values in a table to show one decimal point if they are within the range -999 to 999. If they are outside of this range on either side then I don't want them to show a decimal value.

This is what I'm currently using : 

Total in Thousands + Brackets Decimal =

VAR TotalValue = SUM(vPowerBI_ManufactuerDebt[total])

RETURN

IF(

    ABS(TotalValue) < 1000,

    FORMAT(TotalValue, "£#,0.0,K"),  

    IF(

        TotalValue < -1000,

        FORMAT(TotalValue, "(£#,0,K)"),  

        FORMAT(TotalValue, "£#,0,K")     

    )

)

[Anonymous]

Hi, @Anonymous 

I create a table:

Then create a new measure and try the following DAX:

Total in Thousands + Brackets Decimal = 
VAR TotalValue = SUM('Table'[total])
RETURN
IF(
    ABS(TotalValue) >= 1000,
    FORMAT(TotalValue, "£#,0,K"),  
    FORMAT(TotalValue, "£#,0.0,K")     
)

Here is my preview:

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thankyou for your reply. I have noticed that there is also an error in the way that minus values are displaying from this measure in both my data and the data from your example. The value of -990.50 should be displayed as -1K and not -990.5K as this would give the impression of the value being -990,500.

I'm getting the same result in my data, how can I change the measure to stop this from happening? 

[ajohnso2]

Because your outer IF is evaluating ABS() <1000 your inner if will never get evaluated.