Put a dash in matrix value when it is blank

[poweruser55]

I have a power BI formula where I show the raw number and the percentage under it. The problem is when there is no data I want a "-" but it is putting a "%" because I have to add the symbol since it doesn't automactially show. Is there a way I can make it a - to ovveride the % when the value is blank. Not the percentage sybmol in the screenshot where that product is blank, the requirement would be a -.

Jan FY22 = VAR curMonth =LOOKUPVALUE('Month Parameter'[CurrentCycle],'Month Parameter'[ID],25) VAR curScenario =LOOKUPVALUE('Current Cycle Parameter'[CurrentCycle],'Current Cycle Parameter'[ID],1) VAR priorMonth =LOOKUPVALUE('Month Parameter'[CurrentCycle],'Month Parameter'[ID],13)

Return

 IF(CALCULATE(SUM(DemandRawData[ORDERS_SHIPPED]), DemandRawData[SCENARIO]=curScenario,DemandRawData[MONTH]=curMonth) &" " &   ROUND(DIVIDE(CALCULATE(SUM(DemandRawData[ORDERS_SHIPPED]), DemandRawData[SCENARIO]=curScenario,DemandRawData[MONTH]=curMonth) - CALCULATE(SUM(DemandRawData[ORDERS_SHIPPED]), DemandRawData[SCENARIO]=curScenario,DemandRawData[MONTH]=priorMonth),CALCULATE(SUM(DemandRawData[ORDERS_SHIPPED]), DemandRawData[SCENARIO]=curScenario,DemandRawData[MONTH]=priorMonth)),2)*100   = Blank(),"-",CALCULATE(SUM(DemandRawData[ORDERS_SHIPPED]), DemandRawData[SCENARIO]=curScenario,DemandRawData[MONTH]=curMonth) &" " &   ROUND(DIVIDE(CALCULATE(SUM(DemandRawData[ORDERS_SHIPPED]), DemandRawData[SCENARIO]=curScenario,DemandRawData[MONTH]=curMonth) - CALCULATE(SUM(DemandRawData[ORDERS_SHIPPED]), DemandRawData[SCENARIO]=curScenario,DemandRawData[MONTH]=priorMonth),CALCULATE(SUM(DemandRawData[ORDERS_SHIPPED]), DemandRawData[SCENARIO]=curScenario,DemandRawData[MONTH]=priorMonth)),2)*100 & "%")

[Ahmedx]

try like this:

COALESCE(
          SUM('Table'[sales]),
"-")

[poweruser55]

The symbol is still there @Ahmedx