Forum Discussion
DAX comparison operations do not support comparing values of type Text with values of type Integer
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?
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
4 Replies
- HotChilli
Community Champion
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
- 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 valueHomeowner = if([HomeOwnerFlag]="0","Not Homeowner","Homeowner")it executed without error.
