Forum Discussion

michaelmichael's avatar
michaelmichael
Icon for Helper I rankHelper I
6 years ago
Solved

Average and StDev lines on different aggregate charts

I'm trying to develop some control charts on PowerBI... To do this I need to have a line on each chart that can have a Mean, Mean+StDev and Mean-StDev   To do this I'm using this measure formula fo...
Need Help
Tutorial Requests
  • lc_finance's avatar
    lc_finance
    6 years ago

    Hi michaelmichael ,

     

     

    Could you share a sample Power BI file? That will make it easier to help you.

    You can upload your Power BI file to One Drive, Google Drive or other similar tool and share it here.

     

    Let me know,

     

    LC

    Interest in Power BI and DAX templates? Check out my blog at www.finance-bi.com

lc_finance's avatar
lc_finance
Icon for Solution Sage rankSolution Sage
6 years ago

Hi michaelmichael ,

 

 

You can find attached an example for the whole column showing the total standard deviation.

 

Total Standard deviation = CALCULATE(STDEV.P('Table'[Values]), ALL('Table'[x-axis]))

 

As PaulDBrown mentioned, you can use ALL or ALLSELECTED for that.

 

This is what it looks like:

 

Does this help you?

 

Regards,

 

LC

Interested in Power BI and DAX templates? Check out my blog at www.finance-bi.com

 

 

michaelmichael's avatar
michaelmichael
Icon for Helper I rankHelper I
6 years ago

lc_finance PaulDBrown Both, thanks for your help. This does work now, I've got the line across the graph, however the "Total" is not giving me a mean of the values. The mean/average should be 3.08, not 3.29?

 

From the example above, I've drawn up in Excel what I'm trying to get my table to look like: