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

     

jamesrupertball's avatar
jamesrupertball
Frequent Visitor
4 years ago

Thanks for your help.  That didn't quite work though.  It got to the right answer for Type 1 calls but not Type 2 calls. The calculation I am looking for is:

 

Total revenue/Total calls for each call type.

 

So for type 1 that would be ($10 + $25 + $15) / 2 = $25

So for type 2 that would be ($55 + $60) / 1 = $115

 

Thanks,

James

PaulOlding's avatar
PaulOlding
Icon for Solution Sage rankSolution Sage
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])
)