Calculating aggregates in table

---

ibodnar wrote:

Hi everyone, 

 

I'd like to create a new column that shows the total sales of each country in the corresponding row (see the last column in the table). Can you help me which function(s) should I use? 

 

Country	Sales	Sales Over Country
US	10	65
US	25	65
US	30	65
Germany	20	35
Germany	15	35

---

You can try

Sales Over Country =
CALCULATE ( SUM ( 'Table'[Sales] ), ALLEXCEPT ( 'Table', 'Table'[Country] ) )