Forum Discussion

BoPowerBI's avatar
BoPowerBI
Frequent Visitor
6 years ago

Average time calculation, calculated column or measure?

Hi all,   I'm trying to get my head around PowerBI and measures and I couldn't find an answer, please help.   This is an excerpt from my datatable of 18th of June 2020 during different time slots...
Need Help
  • BoPowerBI's avatar
    BoPowerBI
    Frequent Visitor
    6 years ago

    Awesome amitchandak! Just curious: why do you use

    DIVIDE(3, 2) = 1,5

    instead of

    3 / 2 = 1,5

     

    Thanks for your help.

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      6 years ago

      @BoPowerBI , Not sure I got you.

      But Multiplication should be Sum(A*B) not sum(A) * sum(B) . If we want sum(A) * sum(B), we should force a row context

      Similarly, divide should be sum(A)/ sum(B) not Sum(A/B) . A/B is done when you want a simple Avg

      • BoPowerBI's avatar
        BoPowerBI
        Frequent Visitor
        6 years ago

        amitchandak 

        I just meant the difference between mine without divide:

         

        WaitingTimeAvgSec = SUMX(WaitingTable,WaitingTable[NumCalls] * WaitingTable[WaitingTimeAvg] * 86400) / SUM(WaitingTable[NumCalls]

         

        and yours with divide:

         

        MEASURE = divide(SUMX(Table[NumCalls] *Table[WaitingTimeAvg]*86400),SUM(Table[NumCalls]))