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

[Anonymous]

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?

[HotChilli · Accepted solution]

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

[sghanwat]

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.

[HotChilli · Accepted solution]

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

[Anonymous]

Thanks it worked 🙂

[Anonymous · Accepted solution]

Thanks, solved.