FILTER formula and SUM the results

[RvdHeijden]

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 ? 

[v-danhe-msft]

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

[RvdHeijden]

@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

[v-danhe-msft]

Hi @RvdHeijden ,

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

Regards,

Daniel He

[RvdHeijden]

@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

[Johanno]

Hi, try something like this:

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

/Johan

[RvdHeijden]

@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

[Johanno]

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

Before:

After: