How to Change the Blank Value to Text "data not available"

[ADSL]

Hi BI Community Team,

I have created the measure below to calculate current stock qty, but have issue of some team don't have the data then value show the "Blank".

Total Current Stock Qty = SUMX(VALUES(Inventory[cust_code]), [1. Current Stock Qty])

I have been tried to add "+0" at the end of measure, it's working fine. But another visual also show the "0" value.

Any suggestion/advise? 

Thanks and Regards,

[DOLEARY85 · Accepted solution]

Hi,

You could try: 

Total Current Stock Qty = COALESCE(SUMX(VALUES(Inventory[cust_code]), [1. Current Stock Qty]),"Data Not Available")

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍