topic Re: DAX comparison issue troubleshooting in DAX Commands and Tips

DAX comparison issue troubleshooting

Anonymous — Fri, 07 Mar 2025 11:59:21 GMT

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

Re: DAX comparison issue troubleshooting

bhanu_gautam — Fri, 07 Mar 2025 13:51:42 GMT

Anonymous , Share DAX code or Use Values in your formula

Re: DAX comparison issue troubleshooting

Anonymous — Fri, 07 Mar 2025 15:01:39 GMT

There are several types formulas in report:

cases by tp1 = COUNT ( RRP_CustomerCare[Task_Id] ) / CALCULATE ( COUNT( RRP_CustomerCare[Task_Id] ), ALL ( RRP_CustomerCare[Touchpoint_Name] ) )

Codentify_ = LOOKUPVALUE(Devices[serial],Devices[Device_Guid],RRP_CustomerCare[Device_Guid])

completed task1 = COUNT ( RRP_CustomerCare[Task_Id] ) / CALCULATE ( COUNT( RRP_CustomerCare[Task_Id] ), ALL ( RRP_CustomerCare[Task_Code] ) )

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"

)

Re: DAX comparison issue troubleshooting

johnt75 — Fri, 07 Mar 2025 15:35:30 GMT

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

Re: DAX comparison issue troubleshooting

Anonymous — Fri, 07 Mar 2025 15:45:05 GMT

They do, all the types are persumably correct.

Re: DAX comparison issue troubleshooting

bhanu_gautam — Fri, 07 Mar 2025 15:50:22 GMT

Anonymous 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"
),
""
)

Re: DAX comparison issue troubleshooting

Anonymous — Wed, 30 Apr 2025 07:51:42 GMT

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

Re: DAX comparison issue troubleshooting

Anonymous — Mon, 05 May 2025 12:13:11 GMT

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

Re: DAX comparison issue troubleshooting

Anonymous — Thu, 08 May 2025 09:44:04 GMT

Hi @Pepi151101,

Regards,
Vinay Pabbu

Re: DAX comparison issue troubleshooting

Anonymous — Mon, 12 May 2025 11:56:46 GMT

Hi @Pepi151101,

Regards,
Vinay Pabbu