avg amount with sum

[Anonymous]

Hi

i have data like below:

 

I wrote dax for avg amount:

Avg amount  = CALCULATE(AVERAGE(‘table1[Amount]),filter(ALLEXCEPT(table1,table1

[Date],table2[Area])))

How to find total amount 5.31 based on avg amount?

[danextian]

Hi @Anonymous,

Based on your screenshot, you seem to be trying to get the average of average. Example for 4/11, the average is 0.45 and then you want to calculate the average for all the dates.

Create two measures using these:

Avg of Amt =
AVERAGE ( 'Table'[Amount] )

Avg of Avg of amt=
AVERAGEX ( ALL ( Table[Date] ), [Avg of Amt] ) )

The above formula calculates the sum of the average for each day then divides it by the number of days.

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may try a similar way as shown here.

[Anonymous]

Thanks for sharing the link

[Anonymous]

based on date and area wise average amount is calculated

we can see single date(04/04/2018) amount is 0.05 and average amount 0.05

            single date multiple times(04/09/2018) amount is 0.95, 1.5, 1, 0.5 , 0.65 and average amount 0.92

based on the above average amount calculations . Find total average amount : 5.31

can you please assist?