cancel
Showing results for
Did you mean:
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
Member

## Re: FILTER formula and SUM the results

Hi, try something like this:

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

/Johan

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
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:

After:

Community Support Team

## Re: FILTER formula and SUM the results

Hi @RvdHeijden ,

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.
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

## 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.
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