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
Hi:
You could make a summary table and then do STD.P on a column after the results have been aggregated. But do you want STD on number of observations or maybe some other column. Your STD will be more useful if everything is always the same.
New Table:
Summary_Tble =ADDCOLUMNS(
SUMMARIZE(Table1, Table1[Month], Table1[Major]),
"No. Issues", SUM(Table1[Number of Issues Reported] )
Issues STD = = STDEV.P(Summary_Tble,Summary_Tble[No. Issues])
It could help you to have a Date Table all set up and record your fact table entries by date.
* Note on STD below:
STDEV.P assumes that the column refers to the entire population. If your data represents a sample of the population, then compute the standard deviation by using STDEV.S
I hope I have answered your question. Thanks..
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