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 total amount 5.31 based on avg amount?

 

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks for sharing the link

  • 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.