Calculate the total average of the average of a group

[TapiaMercasid]

I have a Data that register by products. however the total ticket value is repeating. I want to calculate this colummn and get the average per order but also the total average.

In this example I only have 2 orders:

BE06639932 and BE06639291

I know if I calculate average I will get the total ticket price per order. However I need a total average of this average.

If I do an average for the collumn I will get 2,274.57

but the total average I need is 2,144.67

[amitchandak · Accepted solution]

@TapiaMercasid . Based on what I got

A new measure 

Averagex(Values(Table[N*Order]), calculate(Average(Table[Total Ticket])))