topic Re: DAX comparison operations do not support comparing values of type Text with values of type Integer in DAX Commands and Tips

DAX comparison operations do not support comparing values of type Text with values of type Integer

Anonymous — Sat, 29 Jun 2019 14:08:46 GMT

I facing the error for newly created columns.

Total_Review_Not_Blocked =

IF('4-all_daily_companies_review_listing'[Total_Review_Moderated]=1 &&

'4-all_daily_companies_review_listing'[is_blocked]=0 &&

OR('4-all_daily_companies_review_listing'[is_overridden]=1,'4-all_daily_companies_review_listing'[is_overridden]=0),

1,0)

Total_Review_Published =

IF('4-all_daily_companies_review_listing'[Total_Review_Not_Blocked]=1 &&

NOT(ISBLANK('4-all_daily_companies_review_listing'[company_id_captured])),

1,0)

Power BI return with this error msg: DAX comparison operations do not support comparing values of type Text with values of type Integer

Anyone can solve this issue?

Re: DAX comparison operations do not support comparing values of type Text with values of type Integer

HotChilli — Sun, 30 Jun 2019 18:52:10 GMT

The first thing is to check the data type of all the columns in the DAX formulas:

[Total_Review_Moderated]
[is_blocked]
[is_overridden]

[Total_Review_Not_Blocked]
[company_id_captured]

They should all be a number

Re: DAX comparison operations do not support comparing values of type Text with values of type Integer

Anonymous — Tue, 09 Jul 2019 02:15:33 GMT

Thanks, solved.

Re: DAX comparison operations do not support comparing values of type Text with values of type Integer

sghanwat — Mon, 23 May 2022 08:38:56 GMT

I got 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." for new column.

Homeowner = if([HomeOwnerFlag]=0,"Not Homeowner","Homeowner")

I only changed type of comparison value

Homeowner = if([HomeOwnerFlag]="0","Not Homeowner","Homeowner")

it executed without error.

Re: DAX comparison operations do not support comparing values of type Text with values of type Integer

Anonymous — Tue, 05 Jul 2022 04:38:21 GMT

Thanks it worked 🙂