Forum Discussion

matdel's avatar
matdel
Helper I
5 years ago
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....
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    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's avatar
matdel
Helper I
5 years ago

Yes, 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's avatar
Pragati11
Super User
5 years ago

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's avatar
    matdel
    Helper I
    5 years ago

    Thank you!! it works 🙂