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.

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

Anonymous,

 

You may try a similar way as shown here.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks for sharing the link