Divide two columns DAX

[Anonymous]

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?

[Greg_Deckler]

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

[Anonymous]

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 · Accepted solution]

@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

[sgsukumaran]

 Your calcualtion should be

LEADTIME =

 aWORKFLOWWORKITEMTABLE[COUNTRECID]/aWORKFLOWWORKITEMTABLE[DIFFERENCEINDAYSV2] 

[sgsukumaran]

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