Forum Discussion

mrothschild's avatar
mrothschild
Icon for Continued Contributor rankContinued Contributor
7 years ago
Solved

calculating standard deviations from Matrix visual

PBIX file is here: https://www.dropbox.com/s/uasonb98zmz41xw/ATV%2C%20growth%20and%20indexing.pbix?dl=0   I have a matrix visual that appears as follows, except for the StdDev column on the right. ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi mrothschild,

     

    Please try this measure.

    Measure =
VAR a =
    SELECTCOLUMNS ( 'Data', "value", [Value] )
RETURN
    STDEVX.S (
        SUMMARIZE ( 'Data', 'Calendar'[Year], Data[Attribute] ),
        IF ( [Annual % change] <= 1, [Annual % change], BLANK () )
    )

    calculating-standard-deviations-from-Matrix-visual

     

    BTW, DO NOT share anything confidential here.

     

    Best Regards,

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi mrothschild,

 

Please try this measure.

Measure =
VAR a =
    SELECTCOLUMNS ( 'Data', "value", [Value] )
RETURN
    STDEVX.S (
        SUMMARIZE ( 'Data', 'Calendar'[Year], Data[Attribute] ),
        IF ( [Annual % change] <= 1, [Annual % change], BLANK () )
    )

calculating-standard-deviations-from-Matrix-visual

 

BTW, DO NOT share anything confidential here.

 

Best Regards,

mrothschild's avatar
mrothschild
Icon for Continued Contributor rankContinued Contributor
7 years ago

Thank you!