Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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_blo...
Format
values
  • HotChilli's avatar
    HotChilli
    7 years ago

    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's avatar
    Anonymous
    7 years ago

    Thanks, solved.

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks, solved.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks it worked 🙂