Forum Discussion

GCGradwell's avatar
GCGradwell
Icon for Helper I rankHelper I
10 years ago
Solved

Average Revenue per Unique Customer

Hi everyone,   I am trying to generate an Average Revenue per Customer column in Power BI. I have data on each sale made to a customer, including their Customer ID, the revenue generated from the s...
Need Help
  • GCGradwell's avatar
    GCGradwell
    10 years ago

    Hi all,

     

    Solution was much simpler than I thought and was a 2 step solution. 

     

    All I needed to do was create one measure: Distinctcount Customers = DISTINCTCOUNT(Customer ID)

     

    Then I created a second measure which used this measure in it:

     

    Average Revenue per Customer = SUM(Invoices[Revenue])/[Distinctcount Customers]

     

     

    I am still very much new to the software, so apologies for missing this one!

     

    Thanks,

     

    Greg

muruganselva's avatar
muruganselva
Frequent Visitor
1 year ago
Average_sales_Per_Customer =
DIVIDE (
    CALCULATE ( SUM ( Orders[Sales] ), ALLEXCEPT ( Orders, Orders[Customer ID] ) ),
    CALCULATE (
        COUNT(  Orders[Order ID] ),
        ALLEXCEPT ( Orders, Orders[Customer ID] )
    )
)