Forum Discussion

Noadekat's avatar
Noadekat
New Member
2 years ago
Solved

ERROR BETWEEN INTEGER AND TEXT

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! 
  • Damian_CT_Nom's avatar
    Damian_CT_Nom
    2 years ago

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

2 Replies

  • Damian_CT_Nom's avatar
    Damian_CT_Nom
    Icon for Helper I rankHelper I
    2 years ago

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