DAX Function for Consolidated Calculation

First, in Power Query you have to transform your table into this form

Table 1
Cod | Consumption | Group|LinkId
656 | 10                    | A       |656
657 | 15                    | B       |656
658 | 05                    | C       |656

LinkId should be a hidden field. Second, you can create a measure 

[Total Consumption] =
	calculate(
		sum ( 'Table 1'[Consumption] ),
		all ( 'Table 1' ),
		values ( 'Table 1'[LinkId] )
	)

Best

D.