Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
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
@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
Hi @RvdHeijden ,
What is your desired result? Could you please careate it in excel and post a picture here?
Regards,
Daniel He
@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
Hi, try something like this:
TableB = SUMMARIZECOLUMNS(TableA[City];"Value";SUM(TableA[Value]))
/Johan
@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
Ok, that's what I thought I did. I summarized the table per city, except that 200+200=400 and not 300.
Before:
After:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |