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]))