Forum Discussion

BeaudryL's avatar
BeaudryL
Frequent Visitor
1 year ago
Solved

Possible to calculate standard deviation based on a matrix summary column?

    https://www.dropbox.com/scl/fi/9ise1lk7e442f5vvgpfzh/StdDev-Test-Cleaned.pbix?rlkey=sj822rz8594jmj6y6bu7dpqhe&st=f1yyifhn&dl=0   https://www.dropbox.com/scl/fi/c7lz8k1sc7ceeyo595i58/Std...
  • Fowmy's avatar
    1 year ago

    BeaudryL 

    Please use this measure:

    STD Dev = 
    VAR __MeanByClinician = 
        ADDCOLUMNS(
            SUMMARIZE( MENTORS , MENTORS[Clinician] ),
            "@Mean" , CALCULATE( AVERAGE( MENTORS[Response.Value] ) )
        )
    VAR __StdDev = STDEVX.P( __MeanByClinician , [@Mean] )
    RETURN
        __StdDev