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

[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.