Help - Standard Deviation of Summarized Column

[Anonymous]

Hi,

I would like to request your help to create a measure that calculates the Standard Deviation of a summarized column, I have this table:

Table

ID	Value
A	2
A	3
B	4
B	5
C	6
C	7

I need to calculate the Standard Deviation, but I need to do it after sumarizing the values of each ID as follows:

ID	Sum Value
A	5
B	9
C	13

So, I just need the measure that gives me the final STDev which would be: 4

Thanks in advance

[AlB · Accepted solution]

Hi @Anonymous 

Measure =
STDEVX.S ( DISTINCT ( Table1[ID] ), CALCULATE ( SUM ( Table1[Value] ) ) )

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[Anonymous]

Hi @AlB 

Works amazing, Thanks.