Forum Discussion

wooand's avatar
wooand
Helper II
9 years ago
Solved

Calculating Percentage Values

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

 

Tips and Tricks
  • nickchobotar's avatar
    nickchobotar
    9 years ago

    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 -

3 Replies

  • nickchobotar's avatar
    nickchobotar
    Skilled Sharer
    9 years ago

    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 -