Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Help - Average and Standard Deviation from a Summarized Column based on Another

Hi,   I would like to request your help with the following inquiry, I need to create two measures that allow me to calculate the Average and Standard Deviation based on the following scenario:   ...
daxer-almighty's avatar
daxer-almighty
Icon for Solution Sage rankSolution Sage
5 years ago

Here are your measures:

 

[Average] =
AVERAGEX(
    DISTINCT ( T[ID] ),
    CALCULATE( SUM[Value] )
)

[Standard Dev.] =
STDEVX.S(
    DISTINCT ( T[ID] ),
    CALCULATE( SUM[Value] )    
)