Calculating Percentage Values

[wooand]

So, in the table below I need to calculate the 'Percentage Volume' and 'Percentage Cost' columns.  Can anyone help me please?

[nickchobotar · Accepted solution]

Hi @wooand

Here you go:

Percentage Volume = 
DIVIDE(
	SUM(Table1[Total Volume]),
	CALCULATE(
		SUM(Table1[Total Volume]),
		ALLSELECTED()
	)
)



Percentage Cost = 
DIVIDE(
	SUM(Table1[Total Cost]),
	CALCULATE(
		SUM(Table1[Total Cost]),
		ALLSELECTED()
	)
)

Thanks, N -

[wooand]

Perfect.  Many thanks indeed @nickchobotar.  You've saved my keyboard from a beating!

[nickchobotar]

Thank you @wooand