Forum Discussion
STDEV DAX when using row with value 1
Hi:
Please see file. You willl notice I have summary table in and have set up a date table. I made up the data points but results appear to work as intended. What do you think?
https://drive.google.com/file/d/1ibEFS6MXsidsA3ny7_KnDY-UAnJ0UOde/view?usp=sharing
Thanks for the response. I will try your solution and respond in the am. STDEV on Issues and have the STDEV calculate based off the end-users date selection. My average and Sum works this way but see why the STDEV doesnt. Again, will try what you suggested tomorrow morning. Thanks again.
Yes Sorry. I am doing a poor job at explaining. Below is a sample of the data layout and a quick pivot of what I want it to do.
LAYOUT SAMPLE
| MONTH | MAJOR | ISSUES |
| 2022-2 | AAA | 1 |
| 2022-2 | BBB | 1 |
| 2022-3 | AAA | 1 |
| 2022-3 | BBB | 1 |
| 2022-4 | AAA | 1 |
| 2022-4 | BBB | 1 |
| 2022-5 | AAA | 1 |
| 2022-5 | BBB | 1 |
| 2022-2 | AAA | 1 |
| 2022-2 | BBB | 1 |
| 2022-3 | AAA | 1 |
LAYOUT AND CALC I need that Standard Dev to create Upper and Lower Control Limits for the chart.
| MAJOR | 2022-2 | 2022-3 | 2022-4 | 2022-5 | Grand Total |
| AAA | 2 | 5 | 5 | 7 | 19 |
| BBB | 3 | 5 | 6 | 5 | 19 |
| Grand Total | 5 | 10 | 11 | 12 | 38 |
| STDEVIATION | |||||
| AAA | 1.26 | ||||
| BBB | 1.89 |