Reg:To dispaly "-" in Numeric column

[gladies123]

Hi Team,

Kindly Help me to find a solution to display a "-" in numeric column , i have attached the image for your reference

for example if CP and W doesn't have value which belongs to single(status) instead of blank it has to display "-" but when i am trying to do it in dax it shows below error message

"Expressions that yield variant data-type cannot be used to define calculated columns."

[amitchandak · Accepted solution]

@gladies123 , You have to create statements like

coalesce(format([measure], "#,###","-")