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

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

jamesrupertball , Seem like sum till product Avg post that, Try like this with Type in visual

 

AverageX(values(Table[Product]), calculate(Sum(Table[Revenue]) ) )