Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Standard Deviation by Group

Hi and thank you in advance,   Big Picture: I need to create a flag that tells me when a value exceeds 95% confidence interval (the accepted tolerance limit in this case). These flags will then be ...
DAX
Standard Deviation
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You could create a summary table like

Summary Table =
SUMMARIZECOLUMNS (
    'Table'[Bucket],
    "Average", AVERAGE ( 'Table'[Value] ),
    "Std Dev", STDEV.P ( 'Table'[Value] )
)

and then link that to your main fact table. You would then be able to create columns on your fact table which refer to the summary table, e.g. 

Flag =
IF (
    'Table'[Value]
        > RELATED ( 'Summary Table'[Average] ) + RELATED ( 'Summary Table'[Std dev] ),
    1,
    0
)