Forum Discussion

rulloa's avatar
rulloa
Regular Visitor
9 years ago
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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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