Forum Discussion

rockonron's avatar
rockonron
Frequent Visitor
10 years ago
Solved

Standard deviation across the entire range

Hello Guys,   New to Power BI so please excuse me if my question sounds strange.   I was looking for a way to store a global variable that can be used across a report let me explain.   We have ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi rockonron,

     

    Based on my understanding, you want to add a line in a column chart to display standard deviation values for all profits, right?

     

    In your scenario, you can create a measure use STDEV.P( ) function like below:

     

    Standard deviation = CALCULATE( STDEV.P(Sheet4[profit]), ALLSELECTED( Sheet4[customer]) )

     

    Then place this measure in Line values property like below:

     

     

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
10 years ago

Hi rockonron,

 

Based on my understanding, you want to add a line in a column chart to display standard deviation values for all profits, right?

 

In your scenario, you can create a measure use STDEV.P( ) function like below:

 

Standard deviation = CALCULATE( STDEV.P(Sheet4[profit]), ALLSELECTED( Sheet4[customer]) )

 

Then place this measure in Line values property like below:

 

 

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

  • rockonron's avatar
    rockonron
    Frequent Visitor
    10 years ago

    Thanks v-qiuyu-msft thats perfect, have applied it to some test data and seems to work as planned.