Forum Discussion
Solved
sum and average
Hello everyone, the question is: I have the following table. Customer Sub Customer Month N° Amount A AX 1 1000000 31 A AX 2 950000 28 A AX 3 902500 31 A AX 4 85737...
Hi rulloa,
Create the following measures in your table and create a Matrix visual as shown in below screenshot.
SumAmountbycustomer = CALCULATE(SUM('Table'[Amount]),ALLEXCEPT('Table','Table'[Customer]))
countofsubcustomer = CALCULATE(DISTINCTCOUNT('Table'[Sub Customer]),ALLEXCEPT('Table','Table'[Customer]))
Average = [SumAmountbycustomer]/[countofsubcustomer]
Thanks,
Lydia Zhang
