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

Anonymous , Share DAX code or Use Values in your formula

  • 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

        They do, all the types are persumably correct.

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