Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • jennratten's avatar
    jennratten
    4 years ago

    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])
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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!