power bi sum small groups to 'other' code example

Example: power bi sum group by

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