ERROR BETWEEN INTEGER AND TEXT

[Gelain]

Hello!

I created a calculated table, but the following error occurred in the formula:

FORMULA = FILTER (PBICAIXACNPJ; PBICAIXACNPJ[CODE] = "3")

DAX comparison operations do not support the comparison of Integer-type values ​​with values ​​of type Text. Consider using the VALUE or FORMAT function to convert one of the values. I changed the data type, but it did not work.

Please help me.

[JoHo_BI · Accepted solution]

Try not using quote marks for the 3, just leave it as is. 

Quote marks should only be for text values, otherwise it'll auto chang ethe datatype to text. 

[Gelain]

@JoHo_BI,

Thanks for helping me. I did not realize this detail!