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...
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"
    ),
    ""
)
 
 
bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

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