Average Revenue per customer

[GCGradwell]

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 sale, which Department the sale was made in and the type of subscription package was purchased.

Since some customers only buy one item and others buy multiple, the Average Revenue per Customer must be per unique customer.

My approach thus far has been to create a new column with DAX formula: 

Average Revenue per Customer = SUM('MyData'[Sales])/DISTINCTCOUNT('MyData'[Customer ID])

This is not returning the desired result as I am getting a much lower Average Revenue per Customer value than expected.

The software is very new to me apologies if this is a basic question or if it is worded poorly.

Thanks in advance for any help.

[ankitpatira · Accepted solution]

@GCGradwell visuals in power bi will take care of that for you. say for example you want to visualise that in column chart all you need to do is drop customer column in Axis area, revenue column in Values area and then click on dropdown arrow for Values column and select average.

[GCGradwell]

Thank you very much!