topic Re: FILTER formula and SUM the results in Desktop

FILTER formula and SUM the results

RvdHeijden — Fri, 15 Feb 2019 15:04:55 GMT

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

Re: FILTER formula and SUM the results

Johanno — Fri, 15 Feb 2019 15:15:03 GMT

Hi, try something like this:

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

/Johan

Re: FILTER formula and SUM the results

RvdHeijden — Fri, 15 Feb 2019 16:24:39 GMT

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

Re: FILTER formula and SUM the results

Johanno — Sat, 16 Feb 2019 13:04:36 GMT

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

Before:

After:

Re: FILTER formula and SUM the results

v-danhe-msft — Wed, 27 Feb 2019 09:41:27 GMT

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

Re: FILTER formula and SUM the results

RvdHeijden — Thu, 28 Feb 2019 07:50:17 GMT

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

Re: FILTER formula and SUM the results

v-danhe-msft — Thu, 28 Feb 2019 07:57:00 GMT

Hi RvdHeijden ,

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

Regards,

Daniel He

Re: FILTER formula and SUM the results

RvdHeijden — Sat, 09 Mar 2019 12:38:00 GMT

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 A 10

etc

Summarized in a new table with these results

Area A, 40 houses, 400 meters

Areau B, 30 houses, 1500 meters