Replace (Blanks) with 0

[gauravnarchal]

How can I replace with blank with 0 when there is no value returned in the table? If I add (+0) to the below measures it does not work.

Converted Count = COUNT(Data[Invoice No])

Not Converted Count = COUNTBLANK(Data[Invoice No])

Total Enquiry Count = COUNT(Data[Client Name])

Conversion Ratio % = [Converted Count] / [Total Enquiry Count]

When i use ISBLANK it opens all data off. How can i handle this?

[gauravnarchal · Accepted solution]

Hi @Keith-Sayer  - Thank you for your help. I have modified your suggestion slightly to handle the results.

Converted Count =

var countinv = COUNT(Data[Invoice No])

return IF([Total Enquiry Count] >0,if(Isblank(countinv)=true(),0,countinv))

[v-cgao-msft]

Hi @gauravnarchal ,

Did the Keith's answer helped you? If so, please consider marking the most helpful answer as a solution, as this will help people searching the forum for similar questions in the future to find answers more quickly. Thanks in advance!

If the problem is still unresolved, you can continue to add details of the problem below and feel free to contact us.

Best Regards,
Gao
Community Support Team

[Keith-Sayer]

Variables work great for this. Example:

Converted Count =
var countinv = COUNT(Data[Invoice No])
return if(Isblank(countinv)=true(),0,countinv)