How to compute a standard deviation of a calculated column (matrix structure)

[t_guet01]

Hi guys,

I am currently trying to compute the standard deviation based on a calculated column. I want to compute the deviation of gross revenue share within a continent per group. Say, e.g.: Group A makes 17.5 % of the gross revenue from total Africa. 

I now would like to compute the standard deviation of the values from Group A across the Continent. So 17.5 %, 15.42 %, ..., 19.19 %. I tried "STDDEV.P" over the calculated column with the same formula as the gross revenue share, but that doesn't work.

Any ideas? Please find the respective files here:

https://www.dropbox.com/sh/1rknfclljs8sigp/AADj8XxAkJW9YTE5UfJFJzWwa?dl=0

Thank and best!

[mahoneypat · Accepted solution]

You can try something like this

GR Share STD = STDEVX.P(VALUES(Table[Continent]), [Gross Revenue Share Measure])

or you can use ALLSELECTED(Table[Continent]) instead of VALUES depending on where you are doing this calculation.

Pat

[t_guet01]

Perf, thank you Pat! 🙂

Knew it was something obvious, didn't see the forest for the trees.