Standard Deviation of a data set

[Anonymous]

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.

[TeigeGao · Accepted solution]

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