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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I was able to get it no problem. Can you do a quick mock up of what you would like the result to be? Having a little trouble seeing the required output.

      • mweber's avatar
        mweber
        Frequent Visitor
        7 years ago

        Awesome! I'm looking to have a visual that looks something like this:

         

         

        Avg Units/Week is the previous measure I created and was hoping to have this new StD next to it. This way I can create a slicer to toggle the timeframe... hoping to answer questions around averages & standard deviations for certain periods.