Replace blank value with hyphen giving error

[nehamaru1985]

HI Everyone,

I am stuck with one issue , I want to replace blank value with "-" and for that i am using below formula

__M Cost K$ =
var __MCostK = DIVIDE(CALCULATE(sum('Drivers'[Allocation]), 'Drivers'[Measurement] = "PH"), 1000)
RETURN
IF(NOT(ISBLANK(__MCostK )),__MCostK ,"-")

Facing this issue 

Kindly help me to resolve this issue 

[AsNa_92 · Accepted solution]

Hi,

you can just simply change the formating of the new measure as below:

1-create new measure: 

New Measure = CALCULATE(SUM(TableName[ColumnName])) + 0

2- change the formatting of the new measure

#,0.00;(#,0.00);"-"

[nehamaru1985]

Thank you @AsNa_92 Its working 

[rajendraongole1]

Hi @nehamaru1985 -Can you modify the formulae as below:

__M Cost K$ =
VAR __MCostK = DIVIDE(CALCULATE(SUM('Drivers'[Allocation]), 'Drivers'[Measurement] = "PH"), 1000)
RETURN
IF(
NOT(ISBLANK(__MCostK)),
FORMAT(__MCostK, "0.00"), -- Formats the number as a string
"-"
)

Let me know if this works for you!

[nehamaru1985]

HI @rajendraongole1 

Still facing same issue , Kidnly help

__MnS K$ =
var _MnSK = DIVIDE(CALCULATE(sum('Fact'[Allocation]), 'Fact'[Measurement] = "PH"), 1000)
RETURN
IF(NOT(ISBLANK(_MnSK)),FORMAT(_MnSK,"0.000"),"-")