Create a new Colunm that subtotals other rows

[LAndes]

Hi,

This may be a stupid questions, but hopefully someone can help. I am trying to create a new column with Total Income. I have a sheet that looks like this. I have a list of individuls who are also part of households. Each indivual has income and I want a column that list the Housholds total income. So my file looks like this:

Person	Household	Income
A	Smith	$5
B	Smith	$10
C	Jones	$5
D	Jones	$20

I know that i can create a new measure "Total Income= Calculate(sum(Income)) and then create  a table in the visulization field that has total income, but what i would really like is another COLUMN that looks like this:

Person	Household	Income	Total HH Income
A	Smith	$5	$15
B	Smith	$10	$15
C	Jones	$5	$25
D	Jones	$20	$25

Any ideas?

[Vvelarde · Accepted solution]

@LAndes

Hi,

Use this in your new column:

Total HH Income = CALCULATE(SUM(Table1[Income ]),ALLEXCEPT(Table1,Table1[Household]))