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])