cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RvdHeijden Member
Member

FILTER formula and SUM the results

I have a table wheren i want to SUMMARIZE (i think) the results from a different table.

 

In one table i have multiple rows with values for instance a City (Values aren unique) and an amount for certain jobs.

Ive already summarized the column 'City' to a new table where they are unique.

 

What i want is that, in this new table, it checks the other table (per City) and sums all the amounts to one amount

 

Table A

City A          500

City A          500

City B          200  

City A        1000

City B          200

City A         100

 

Table B (the new one)

City A        2100 

City B          300

 

It looks so simple but i can't get it to work

Who can help me out here ? 

 

7 REPLIES 7
Johanno Member
Member

Re: FILTER formula and SUM the results

Hi, try something like this:

TableB = SUMMARIZECOLUMNS(TableA[City];"Value";SUM(TableA[Value]))

/Johan

RvdHeijden Member
Member

Re: FILTER formula and SUM the results

@Johanno why should i use a value if i want to summarize the data ?

I want to summarize based on city and then add all the amounts to a single value for that particular City

Highlighted
Johanno Member
Member

Re: FILTER formula and SUM the results

Ok, that's what I thought I did. I summarized the table per city, except that 200+200=400 and not 300.

 

Before:

Capture.JPG

 

After:

Capture.JPG

 

 

Community Support Team
Community Support Team

Re: FILTER formula and SUM the results

Hi @RvdHeijden ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RvdHeijden Member
Member

Re: FILTER formula and SUM the results

@v-danhe-msft and @Johanno the question isn't solved yet because in the formula i dont want to add a value.

I want to summarize the colums based because if i need to add a 'Value' i have to do that like 200 times

Community Support Team
Community Support Team

Re: FILTER formula and SUM the results

Hi @RvdHeijden ,

What is your desired result? Could you please careate it in excel and post a picture here?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RvdHeijden Member
Member

Re: FILTER formula and SUM the results

@v-danhe-msft the result is pretty simple

 

I have 1 table with 5000 adresses devided in like 100 different areas, the first part is to summarize these area's to 1 unique list.

That is the simple part and that part is done.

But every adress has a certain amount of meters and they should be added to one amount

 

So basically if we have 40 houses, all in area A and every house has 10 meters

30 houses in Area and every house has 50 meters

 

Area A                      10

Area B                       50

Area B                       50

Area B                       50

Area A                       10

etc

etc

 

Summarized in a new table with these results

 

Area A, 40 houses, 400 meters

Areau B, 30 houses, 1500 meters