Forum Discussion
Solved
Average X
Hello I'm trying to do a control chart by using the lines graphic. For that I need to add on the graphic a constant line that will be the average of all my results from the column Result of my tab....
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
