Forum Discussion
dhanekula1996
Helper I
Helper IDynamic mean for control charts based on rules
Hello, I am trying to create a control chart based on a set of rules. My mean and standard deviation should change based on set of mentioned rules. Standard rules to calculate the control chart are ...
djurecic
Super User
Super UserHi dhanekula1996,
You should probably create measures to do all of these calculations, then add the measures to a visual.
Power BI does have a standard deviation function:
https://learn.microsoft.com/en-us/dax/stdev-p-function-dax
dhanekula1996Helper I
Helper II have tried this for Average calculation but this measure gives me a constant Average value. I need to dynamically vary the average based on the rules mentioned.
Avg Returns_c = CALCULATE(AVERAGEX('01_Date',[ITEM return rate]),ALLSELECTED('01_Date'[Calendar_Date]))