cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gelain
Frequent Visitor

ERROR BETWEEN INTEGER AND TEXT

 

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.

1 ACCEPTED SOLUTION
JoHo_BI
Resolver V
Resolver V

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. 

View solution in original post

2 REPLIES 2
JoHo_BI
Resolver V
Resolver V

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. 

View solution in original post

Gelain
Frequent Visitor

@JoHo_BI,

 

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors