Aggregated Column

[yaudje]

Hi Folks,

Hope someone can help me on this one. Im working on a table but its a bit challenging to do the calculation of a new column which is an aggregate of 2 elements. I have attached a screenshot of the original table sample and the desired output column with remarks. 

Thank you in advance for those who will answer. 

Cheers!

[ryan_mayu]

@yaudje 

pls try this

Column = CALCULATE(sum('Table'[Year1]),ALLEXCEPT('Table','Table'[Sales Rep],'Table'[Customer]))