cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## how to find standard deviation in power bi

Hi,

I have a dataset, here is a screenshot of how i dragged the columns into a table in power bi, i want to find the standard deviation in count of part numbers with respect to priority every month, TIA.

3 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Champion

## Re: how to find standard deviation in power bi

@Jack11

Try as a new column:

``````STD =
CALCULATE(
STDEV.P(Table02[COUNT]),

ALLEXCEPT(Table02,Table02[MONTH],Table02[PRIORITY])
)``````

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

Highlighted
Super User IX

## Re: how to find standard deviation in power bi

@Jack11 - There are 4 standard deviation functions in DAX, STDEV.P, STDEV.S, STDEVX.P, STDEVX.S. If your data represents the entire population, use .P version, otherwise if it is a sample, use the .S version. You should be able to put month and priority in a visual and simply have a measure:

Measure = STDEV.P('Table'[Count of Part Number])

---------------------------------------

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Highlighted
Super User VI

## Re: how to find standard deviation in power bi

To do this as a measure, you can use this expression

``````Count STD =
VAR __summarytable =
SUMMARIZE (
Table,
Table[Priority],
Table[Month],
"@count", COUNT ( Table[Part Number] )
)
RETURN
STDEVX.P ( __summarytable, [@count] )``````

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Proud to be a Super User!

4 REPLIES 4
Highlighted
Community Champion

## Re: how to find standard deviation in power bi

@Jack11

Try as a new column:

``````STD =
CALCULATE(
STDEV.P(Table02[COUNT]),

ALLEXCEPT(Table02,Table02[MONTH],Table02[PRIORITY])
)``````

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

Highlighted
Super User IX

## Re: how to find standard deviation in power bi

@Jack11 - There are 4 standard deviation functions in DAX, STDEV.P, STDEV.S, STDEVX.P, STDEVX.S. If your data represents the entire population, use .P version, otherwise if it is a sample, use the .S version. You should be able to put month and priority in a visual and simply have a measure:

Measure = STDEV.P('Table'[Count of Part Number])

---------------------------------------

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Highlighted
Impactful Individual

Highlighted
Super User VI

## Re: how to find standard deviation in power bi

To do this as a measure, you can use this expression

``````Count STD =
VAR __summarytable =
SUMMARIZE (
Table,
Table[Priority],
Table[Month],
"@count", COUNT ( Table[Part Number] )
)
RETURN
STDEVX.P ( __summarytable, [@count] )``````

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Proud to be a Super User!

Announcements

#### Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

#### Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

#### Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

#### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors
Top Kudoed Authors