Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Revenue PER client -- urgent help needed!

I want to calculate the Average Purchase Value for each of my clients. That is defined as: APV = Total revenue per client/ number of that client's orders. I will then take each average per customer, ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    6 years ago

    Anonymous 

    Try this:

    the model:

     

    And the measures:

     

    Sum of Amount = SUM('DataTable'[Amount])
    Number of Transactions = DISTINCTCOUNT('DataTable'[Transaction ID])
    Average Purchase Value overall = DIVIDE([Sum of Amount]; [Number of Transactions])
    Average Purchase value per customer = AVERAGEX('User ID Table'; DIVIDE([Sum of Amount]; [Number of Transactions]))

     

     

    Which gets you this:

     

ybcrg's avatar
ybcrg
Regular Visitor
6 years ago

Hi

 

For a similar situtaion I had used this measure. Hopefully it works for you

 

Avregae by Group = CALCULATE(AVERAGEX(SalesRegionB,[AverageSales]),GROUPBY(SalesRegionB,SalesRegionB[SalesID]))
 
Accept the solution if it works.