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]), '...
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);"-"

     

     

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

 

 

nehamaru1985's avatar
nehamaru1985
New Member
2 years ago

Thank you AsNa_92 Its working