Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Standard Deviation of a data set

Hi Experts

 

I know that you can work out the std dev of a column using the STDEVS function within Power BI, but how could you work out dynamically the STD DEV of the Revised data as shown in the table below.

 

i want to have the ability to place that STD DEV measure into a card.

Need Help
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    Hi Anonymous ,

    In your scenario, we can create a measure with STDEV.S() function directly like below:

    Measure = STDEV.S(Table1[Column2])

    Then drag the measure to the matrix.

    Best Regards,

    Teige

1 Reply

  • TeigeGao's avatar
    TeigeGao
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Hi Anonymous ,

    In your scenario, we can create a measure with STDEV.S() function directly like below:

    Measure = STDEV.S(Table1[Column2])

    Then drag the measure to the matrix.

    Best Regards,

    Teige