SUMIF In PP

[mikeymay]

It's been a while since I last used PP and it seems I'm quite rusty.....

I have a tables that holds a Category column that has multiple rows and an Income category/column and I want to produce a seperate tabvle with each unique category and the total income.

I thought the following would work

=CALCULATE(SUM(ALLDATA[ROW INCOME],ALLDATA[CATEGORY]=UNIQUEDATA[CATEGORY]))

I'm getting a #ERROR for the function so not sure what I've done wrong.


TIA

 

[sandy666]

How do I SUMIF one PowerPivot table according to the rows of a second PowerPivot table?

I have two tables: one of customers ("Donor"), and one of transactions ("Trans"). In Donor, I want a "Total" column that sums all the transactions by a particular Donor ID, which I would calculate ...

stackoverflow.com