Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

DAX comparison issue troubleshooting

Hello Power BI comunity,

 

I am trying to refresh my data in report but I am keep getting the same error:

 

I did everything I can and I can't find the source of my problem, which column is causing this error.

Any help would be appriciated, please 🙂

 

Petra

 

9 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      There are several types formulas in report:

       

      1. 

      cases by tp1 = COUNT ( RRP_CustomerCare[Task_Id] ) / CALCULATE ( COUNT( RRP_CustomerCare[Task_Id] ), ALL ( RRP_CustomerCare[Touchpoint_Name] ) )
       
       
      2.
      Codentify_ = LOOKUPVALUE(Devices[serial],Devices[Device_Guid],RRP_CustomerCare[Device_Guid])
       
      3.
      completed task1 = COUNT ( RRP_CustomerCare[Task_Id] ) / CALCULATE ( COUNT( RRP_CustomerCare[Task_Id] ), ALL ( RRP_CustomerCare[Task_Code] ) )
       
       
       
       
      4.
      Overdue Task = IF(NOT(ISBLANK(RRP_CustomerCare[Due_Date])) && TODAY()>RRP_CustomerCare[Due_Date] && RRP_CustomerCare[Task_Status] = "WAIT",1,0)
       
      5.
      Task Closed =
      IF(
          RRP_CustomerCare[Task_Status] = "Closed" || RRP_CustomerCare[Task_Status] = "Completed",
          IF(
              ISBLANK(RRP_CustomerCare[Edit_Date]),
              "0 days",
              DATEDIFF(RRP_CustomerCare[Created_Date], RRP_CustomerCare[Edit_Date], DAY) & " days"
          ),
          ""
      )
       
       
      • johnt75's avatar
        johnt75
        Icon for Super User rankSuper User
        1 year ago

        Make sure that Devices[Device_Guid] and RRP_CustomerCare[Device_Guid] both have the same type.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous,

     

    DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

     

    This usually means somewhere in your model (possibly a calculated column, measure, or relationship), you're comparing two columns or values of different data types.

    But one of them is text (e.g., "123") and the other is numeric (e.g., 123).

     

    Regards,

    Vinay

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

     

    Regards,
    Vinay Pabbu

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi @Pepi151101,

       

      As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
      If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

       

      Regards,
      Vinay Pabbu

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi @Pepi151101,

         

        As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
        If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

         

        Regards,
        Vinay Pabbu