cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LAndes Frequent Visitor
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:

PersonHouseholdIncome 
ASmith$5
BSmith$10
CJones$5
DJones$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:

 

PersonHouseholdIncome Total HH Income
ASmith$5$15
BSmith$10$15
CJones$5$25
DJones$20

$25

 

 

Any ideas?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
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]))

 

TotalHH.png




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




1 REPLY 1
Super User
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]))

 

TotalHH.png




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!