Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

TheoC Thanks for your patience. I am sharing the details.

Speed1 = SUM(Table2[Volume])/sum(Table1[Time])
Time = (DATEDIFF('Table1'[start time], 'Table1'[end time],SECOND))

These are two tables linked with each other on ID.If I divide using measure, it gives correct value but if I create a calculated column, it gives wrong value.

I don't know how to share the PBIX file with you.

 

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    Anonymous if there's a relationship using the IDs in both tables, then create following calculated columns:

     

    colRelated = RELATED ( [Volume] ) // This brings the Volume column into the other table

    colDivision = DIVIDE ( [Volume] , [Time] , 0 ) // This divides Volume by Time.

     

    Hope this helps.

    Theo