to make aggregation only go with higher dimension level

[Anonymous]

Hi Masters,

 I want to add a new column in table 1 - the sales aggregation is according to Class column  not to be drill down to item column. How I can achieve it?

Table1
Item	Class	A new column	Not like this
GoldenApple	Fruit	190	70
RoseApple	Fruit	190	30
GreenApple	Fruit	190	40
RedApple	Fruit	190	50
GreenPepper	Veggie	90	65
BellPepper	Veggie	90	10
BalanaPepper	Veggie	90	15
…	…
Table2
Date	Item	Sales
1-Jan	GoldenApple	20
15-Jan	GoldenApple	50
2-Jan	RoseApple	30
1-May	GreenApple	40
1-Jun	RedApple	50
1-Jan	GreenPepper	60
1-Mar	BellPepper	10
1-Jul	BalanaPepper	15
2-Jul	GreenPepper	5
…	….

[ERD]

@Anonymous , do you need a measure for a table visual or a calculated column?

If it's a measure: 

measure_ =
CALCULATE ( SUM ( Table2[Sales] ), ALL ( Table1[Item] ) )

If it's a calculated column:

Column = CALCULATE(SUM(Table2[Sales]), ALLEXCEPT(table1, Table1[class]))

[Anonymous]

I have a question: why it is not 

Sales Class = calculate(sum(Table2[Sales]), all(Table1[Class])) ?
But 
CALCULATE ( SUM ( Table2[Sales] ), ALL ( Table1[Item] ) )

[Anonymous]

Can I take a look the "sales" measure in your visual ?

Thank you ERD!!!!

[ERD]

I don't use it in your formulas, it's just for the visualization. 

sales = SUM(Table2[Sales])