Sum of sales per category and average of it

[Anonymous]

Please can you help a newbie with this? I am lost.

I have the following data: 

date	order number	sales
1/1	1	20
1/1	1	30
2/1	2	40
2/1	2	20
2/1	2	50
3/1	3	5

I wan tho create a label visualisation which will tell me average order value, so just one number.

So far, using the normal AVERAGE function gives me 27,5 and I need it to show me 55 

[smpa01 · Accepted solution]

@Anonymous  does this work for you?

measure = DIVIDE(SUM(tbl[sales]),DISTINCTCOUNT(tbl[order number]))

[Anonymous]

exactly that and so simple! thanks