Average of distinct orders

[Anonymous]

It's frustrating that it's so complicated to find such a simple answer.  

I have a table of unique customers and their orders  (can of course be more than one order (with multiple lines), per customer.  

I have this filter by a customer, and I simply want to find the average value of the unique orders in this list.  Ideally not including zero dollar value.   So, in this case, summing up the three orders below and dividing by the distinct count of orders (orders that are not zero value).   

Any help is appreciated!

[amiller5]

I have a dataset that has 2 years of data by accounts. I want to find the Avg. of the Distinct account names for each year. I have distinct count of account names but because account names is not a value I cannot figure out how to find the average?

[Ashish_Mathur]

Hi,

Try this measure

Measure = averagex(values(Calendar[date]),[your measure])

Ensure that you drag Year and Month name from the Calendar Table.

[amiller5]

So I used the formula above but this is what is showing. The Avg of the number displayed in the table should be 89.8. I have same filters applied. I only want it to show the average of what is displayed in the table. Would that be a different measure?

My measure is:

Avg Account = AVERAGEX(VALUES('Service 1'[Closed Date].[Year]),[Distinct count of Account name])

[Anonymous · Accepted solution]

Ok, just found the solution: 

Average Order Values = AVERAGEX(VALUES(SalesOrdersALL[Order Number]), [Total Sales])

Calculate Average Per Customer Transaction Using DAX In Power BI - Enterprise DNA

[v-shex-msft]

Hi @Anonymous,

Thank you for sharing the DAX expression.😊 I think they may help others who has a similar requirement.
Regards,
Xiaoxin Sheng