Forum Discussion

Arnault_'s avatar
Arnault_
Icon for Resolver III rankResolver III
8 years ago
Solved

Standard deviation using "CALCULATE / FILTER" fx

Dear All,   I am trying to calculate the standard deviation of my sales per product.   I managed to get it per order, but I wanted to consolidate sales per month. Then I created periods equivalen...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    Arnault_

     

    In this scenario, you should modeling your data with 3 columns: Product, Month, Sales. 

     

    Then you can create a your standard deviation measure like: 

     

    =STDEVX.P(VALUES(Table[Month]),[Sales Measure])

    You can put your FILTER in that [Sales Measure]. When you put Product on Rows, it will slice above measure properly.

     

    For more details, please refer to article below:

     

    https://powerpivotpro.com/2013/10/standard-deviation-demystified-in-power-pivot/

     

    Regards,

     

     

     

     

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Arnault_

 

In this scenario, you should modeling your data with 3 columns: Product, Month, Sales. 

 

Then you can create a your standard deviation measure like: 

 

=STDEVX.P(VALUES(Table[Month]),[Sales Measure])

You can put your FILTER in that [Sales Measure]. When you put Product on Rows, it will slice above measure properly.

 

For more details, please refer to article below:

 

https://powerpivotpro.com/2013/10/standard-deviation-demystified-in-power-pivot/

 

Regards,

 

 

 

 

  • Arnault_'s avatar
    Arnault_
    Icon for Resolver III rankResolver III
    8 years ago

    Hi, this is not exactly what I was looking for, but it might help other people. Thanks.