cancel
Showing results for
Did you mean:
Frequent Visitor

## Create a new Colunm that subtotals other rows

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Create a new Colunm that subtotals other rows

@LAndes

Hi,

Use this in your new column:

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

Lima - Peru

Proud to be a Datanaut!

Super User

## Re: Create a new Colunm that subtotals other rows

@LAndes

Hi,

Use this in your new column:

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

Lima - Peru