Waterfall Chart measure with non numeric values

[TeresaV]

I want to create a Waterfall chart with a measure. 

My measure turns the 0 values in "Data N/A".  How can I filter those types of values in Waterfall chart? 

Japan	1
Portugal	2
France	Data N/A
England	5
Italy	6
Spain	412
Russia	10
Germany	1
USA	Data N/A
Canada	Data N/A

This is the table after applying this measure: 
Measure=
var a=CALCULATE('Table'[Value])
return
if( a=0, "Data N/A", calculate(sum('Table'[Value]))


Thanks!
@Jihwan_Kim @amitchandak @Anonymous @daxer-almighty 

[v-luwang-msft]

Hi @TeresaV ,

Could you pls share your pbix file?Remember to remove confidential data.

Best Regards

Lucien