Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

avg amount with sum

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 to...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    You may try a similar way as shown here.

danextian's avatar
danextian
Icon for Super User rankSuper User
8 years ago

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.