Forum Discussion

jamesrupertball's avatar
jamesrupertball
Frequent Visitor
4 years ago
Solved

Calculating average revenue per call

Hello, I am trying to calculate average revenue per call type.  I have a call table and a revenue table.   Call table (shows number of calls by call type):   Call Identifier Call Type 001 ...
  • PaulOlding's avatar
    PaulOlding
    4 years ago

    Hi jamesrupertball 

    Here's a measure to get average revenue per call

    Average Revenue per Call = 
DIVIDE(
    SUM(Revenue[Revenue]),
    DISTINCTCOUNT(Revenue[Call Identifier])
)

     

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

Hi jamesrupertball 

"Essentially sum all of the revenue by call type (from the revenue table) and then divide by the number of calls of that type (from the call table). ", If this rule is strictly followed, then measure can be written as

Measure = 
//from the revenue table
var _totalPerType=CALCULATE(SUM(Revenue[Revenue]),ALLEXCEPT(Revenue,Revenue[Call Type]))
//from the call table
var _numOfCall= CALCULATE(DISTINCTCOUNT('Call'[Call Identifier]),'Call'[Call Type]= MIN(Revenue[Call Type]))
return divide(_totalPerType,_numOfCall)

result

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.