Combining Rows Based on Attributes from Multiple Other Rows

[Anonymous]

Hi,

I'm new to this, sorry if this one is easy.

I'd like to go from this:                  

To this:

Basically consolidate the Counts by Year, Crime and Community.

Thanks so much for your help!

[dedelman_clng]

If you need it as a table

NewTab = SUMMARIZE(Table, Table[Community],
 Table[Year],
 Table[Crime],
 "Count", SUM(Count) )

If you just want it as a measure

Measure = CALCULATE( SUM ( Table[Count] ) )

The measure will recalculate at any level (say, community and crime only)

Hope this helps

David

[PattemManohar · Accepted solution]

@Anonymous Please use "Group By" option in "Power Query Editor"