Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Divide two columns DAX

Hello guys,   I have created three calculated columns :   DIFFERENCEINDAYSV2 = DATEDIFF(aWORKFLOWWORKITEMTABLE[CREATEDDATETIME],aWORKFLOWWORKITEMTABLE[TODAY],MINUTE)/1440   COUNTRECID = COUNT(...
Need Help
Tips and Tricks
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

    I think you should create a MEASURE instead of Calculated Column

     

    LEADTIME =

    Sum(aWORKFLOWWORKITEMTABLE[DIFFERENCEINDAYSV2]) / sum(aWORKFLOWWORKITEMTABLE[COUNTRECID])

     

    I believe...With a calculated column, division occurs first and then the results are summed in a Table Visual. Thats why it gives you inaccurate results

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Can you share some example raw data so that we can recreate what is going on here?

  • sgsukumaran's avatar
    sgsukumaran
    Resolver II
    8 years ago

     Your calcualtion should be

     

    LEADTIME =

     aWORKFLOWWORKITEMTABLE[COUNTRECID]/aWORKFLOWWORKITEMTABLE[DIFFERENCEINDAYSV2] 

    • sgsukumaran's avatar
      sgsukumaran
      Resolver II
      8 years ago

      or Use  Divide(aWORKFLOWWORKITEMTABLE[DIFFERENCEINDAYSV2] , aWORKFLOWWORKITEMTABLE[COUNTRECID)

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hello ,

     

    as you can see the total of these three columns is correct because  28172 / 566 = 49.77. The issue is that the expected result for each rows doesnt work.  on the first row i expected 46.57 and not 8.80.

     

    How can i divide each rows in the good way between column DIFFERENCEINDAYSV2 and ACTIVITYID?

     

     

     

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      8 years ago

      Anonymous

       

      I think you should create a MEASURE instead of Calculated Column

       

      LEADTIME =

      Sum(aWORKFLOWWORKITEMTABLE[DIFFERENCEINDAYSV2]) / sum(aWORKFLOWWORKITEMTABLE[COUNTRECID])

       

      I believe...With a calculated column, division occurs first and then the results are summed in a Table Visual. Thats why it gives you inaccurate results