Forum Discussion

nehamaru1985's avatar
nehamaru1985
New Member
2 years ago
Solved

Replace blank value with hyphen giving error

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 

Need Help
  • AsNa_92's avatar
    AsNa_92
    2 years ago

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

     

     

4 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Icon for Super User rankSuper User
    2 years ago

    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's avatar
      nehamaru1985
      New Member
      2 years ago

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

       

       

       

  • AsNa_92's avatar
    AsNa_92
    Icon for Resolver II rankResolver II
    2 years ago

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