ERROR BETWEEN INTEGER AND TEXT

[Noadekat]

Hello everyone,

Can you please help me with the following formula?

What I want to do is I made a column with numbers where multiple columns where summed, but there are rows which are empty. I want to fill up the empty rows with the number 0. 

The formula I used is:

Totaal aantal fouten bewerkt = if([Totaal aantal fouten] = "" , 0 , [Totaal aantal fouten])

But it doesn't work. I've got the error: DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.

Can you please help me with this?

Thanks in forward! 

[Noadekat]

Yes it does, thank you! 

[Damian_CT_Nom · Accepted solution]

"" is a text, therefore the error. Try using:
= if(ISBLANK([Totaal aantal fouten]), 0 , [Totaal aantal fouten])
that should work