cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.

 

Jack11_0-1596361885963.png

 

3 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Champion
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 🙂

YouTube, LinkedIn





View solution in original post

Highlighted
Super User IX
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])


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

@ me in replies or I'll lose your thread!!!

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
Super User VI
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





Did I answer your question? Please mark my post as a solution! Kudos are also appreciated!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
Highlighted
Community Champion
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 🙂

YouTube, LinkedIn





View solution in original post

Highlighted
Super User IX
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])


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

@ me in replies or I'll lose your thread!!!

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
Impactful Individual
Impactful Individual

Re: how to find standard deviation in power bi

@Jack11  Below screenshot can help you in creating the measure

Standard Dev.PNG

 

Highlighted
Super User VI
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





Did I answer your question? Please mark my post as a solution! Kudos are also appreciated!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
Upcoming Events

Upcoming Events

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

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

Community Blog

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

Top Solution Authors