Forum Discussion
Helper IAverage X
HI matdel ,
In that case you can modify your average caluclation DAX as follows:
AVERAGE RESULT = CALCULATE(AVERAGE('Quality control results'[Result]), ALL('Quality control'))
You don't have to use AVERAGEX to achieve this. Because it evaluates an expression for each row. You need a single average value for your RESULT column therefore you need to use AVERAGE.
Thanks,
Pragati
Super UserHI matdel ,
You can simply add a average line using the Analytics Pane feature on a Line chart visual. You don't need a calculation for it. See an example below:
Thanks,
Pragati
matdelYes, thanks, but actually after I need also to calculate UCL and LCL from the average, to put them on the graphic also
STDEV RESULT = CALCULATE(STDEV.P('Quality control results'[Result]),ALLSELECTED('Quality control results'[Result]))UCL RESULT = [AVERAGE RESULT]+3*[STDEV RESULT]LCL RESULT = [AVERAGE RESULT]-3*[STDEV RESULT]- Pragati11
HI matdel ,
In that case you can modify your average caluclation DAX as follows:
AVERAGE RESULT = CALCULATE(AVERAGE('Quality control results'[Result]), ALL('Quality control'))
You don't have to use AVERAGEX to achieve this. Because it evaluates an expression for each row. You need a single average value for your RESULT column therefore you need to use AVERAGE.
Thanks,
Pragati
- matdel
Thank you!! it works 🙂