power bi sum group by

Total value by category = 
	VAR
		category = [Category]
	RETURN
		CALCULATE(SUM([Value]), FILTER(Table1, [Category] = category))

GROUPBY (<table>, [<groupBy_columnName1>], [<name>, <expression>]… )