Forum Discussion
Divide two columns DAX
Hello guys,
I have created three calculated columns :
DIFFERENCEINDAYSV2 = DATEDIFF(aWORKFLOWWORKITEMTABLE[CREATEDDATETIME],aWORKFLOWWORKITEMTABLE[TODAY],MINUTE)/1440
COUNTRECID =
COUNT(aWORKFLOWWORKITEMTABLE[RECID])
LEADTIME =
aWORKFLOWWORKITEMTABLE[DIFFERENCEINDAYSV2] / aWORKFLOWWORKITEMTABLE[COUNTRECID]
and then i created a table for showing the data based on these 3 colums based on a Userid.
In the following image i expect that the LEADTIME calculated column return from the first row is 25 and not 0.04.
what did i wrong? any suggestions?
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
5 Replies
Can you share some example raw data so that we can recreate what is going on here?
Your calcualtion should be
LEADTIME =
aWORKFLOWWORKITEMTABLE[COUNTRECID]/aWORKFLOWWORKITEMTABLE[DIFFERENCEINDAYSV2]
or Use Divide(aWORKFLOWWORKITEMTABLE[DIFFERENCEINDAYSV2] , aWORKFLOWWORKITEMTABLE[COUNTRECID)
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?
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
