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.

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?