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..
I am trying your code out now and getting that dreaded "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value." Assuming it is something in my setup of the table? I have this linked from a SQL database and it is a stored procedure connected to multiple tables. Probably not why this is happening but unsure. I mirrored exactly what you had written so it has to be something on my end.
Hi:
If the number of issues is always one/event than there can't be any STD becasuse everything is always one. Are you trying to get STD on monthly or weekly issues? Normally the STD would work something like this:
Test 1 - result 40
Test 2 - result 50
Test 3 - result 42
Sum = 132
Avg = 44
STD(pop) = 4.32
But when each result is one the STD = 0.
I hope my reply makes sense to you.
Thank you,
It does. What I was hoping was to get the standard deviation from the sum of each month selected in the slicer. So for instance if the end-user selects the below:
1-2020 with 1000
2-2020 with 2000
3-2020 with 1500
Then in simple form calculate the standard deviation of those three which would be STDEV(1000, 2000, 1500)
Hi:
Maybe your sample data isn't matching your latest example. I see 1 for Jan 2020 but you mention it is 1000? Do you have sample data to share? Just something to represent this issue so I can see those different totals. Thanks