Forum Discussion
Standard Deviation Population - Power Pivot (By Group) Measure
Hi all, I'm trying to build a model using Power Pivot (data is already loaded into power query). I'm having a difficult time trying to create a power pivot measure that would return the Standard D...
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])
Hello - Is your measure calculating on the field in the fact table? Is the lookup column in the visual coming from the dimension table? Is your relationship one (dimension) to many (fact)?