Forum Discussion

mweber's avatar
mweber
Frequent Visitor
7 years ago

Standard Deviation

Hello,   I'm having trouble getting the correct Standard Deviation from a dataset. Here's a subsection of a datset I'm working with: Week Ending Site SKU Nbr Units 1/6/2019 Sycamore 100...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

mweber 

It can be a little tricky. Here's a couple threads that I solved with some-what the same issue. Take a look and see if they help. If not, fire away some questions here

https://community.powerbi.com/t5/Desktop/Getting-Standard-Deviation-on-counts-if-ID-rolled-off-at-month/m-p/699696

 

https://community.powerbi.com/t5/Desktop/Incorrect-Standard-Deviation-of-a-measure/m-p/736707

 

https://community.powerbi.com/t5/Desktop/Standard-deviation-on-average-weighted-price/m-p/699527

mweber's avatar
mweber
Frequent Visitor
7 years ago

Thanks Nick_M! I've looked through your threads and tried a couple things but not sure I'm applying them correctly. So I created this measure to calculate Avg. Weekly Sales:

 

Avg. Units per Week = SUM('Summarized Orders'[Total])/CALCULATE(DISTINCTCOUNT('Summarized Orders'[Calendar Week End]))
 
I was thinking maybe then there was a way to leverage that measure. Tried the addcolumns with no success.
 
Thanks again for the assistance!
 
 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Can you upload some sample data/pbix file?  One drive works well.

     

    Also, always best to use the DIVIDE function and not "/", since th DIVIDE function has built-in error catching. Not the end of the world, but something I found to more helpful than not. 

     

    https://docs.microsoft.com/en-us/dax/divide-function-dax