Forum Discussion
Standard Deviation Population - Power Pivot (By Group) Measure
Try using stdevx.s (evaluate for a sample population, not the entire population), and making your column reference fully qualified, which is a best practice. This means when referencing columns by name, you should include the table with it; when you reference a measure, do not include a table name.
stdevx.s('Week 3', 'Week 3'[Average])
Hi,
The standard deviation still comes back as zero when i tried using any of the listed functions. I'm using the average column (the standard devation column should return the standard deviation population of the Averages column within the grouping of the lookup column). Any idea on what I might be doing wrong?
Try using stdevx.s (evaluate for a sample population, not the entire population), and making your column reference fully qualified, which is a best practice. This means when referencing columns by name, you should include the table with it; when you reference a measure, do not include a table name.
stdevx.s('Week 3', 'Week 3'[Average])Hi,
I tried the measure and it is returning #NUM! on the column. I'm not sure why this isn't working. Other standard deviation DAX are returning zeros. I really don't know why this is happening?
I figured it out! What was happening was that I grouped by the values in Power Query to create the average column. The DAX Standard Deviation measure formula would not work off this column. I created another table with the original values and joined in the "Avevage" column. Then I was able to utilize the STDEVX.P measure in the Pivot Table. Thank you for your help!