DAX comparison issue troubleshooting

[Pepi151101]

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

[v-vpabbu]

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

[v-vpabbu]

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

[v-vpabbu]

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

[v-vpabbu]

Hi @Pepi151101,

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

[bhanu_gautam]

@Pepi151101 , Share DAX code or Use Values in your formula

[Pepi151101]

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"

    ),

    ""

)

[bhanu_gautam]

@Pepi151101 Try updating

Overdue Task = IF(NOT(ISBLANK(RRP_CustomerCare[Due_Date])) && TODAY()>RRP_CustomerCare[Due_Date] && RRP_CustomerCare[Task_Status] = "WAIT",1,0)

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]

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

[Pepi151101]

They do, all the types are persumably correct.