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.

So I have done this measure : 

AVERAGE RESULT = CALCULATE(AVERAGEX('Quality control results','Quality control results'[Result]),ALLSELECTED('Quality control'[Result]))

But it doesn't work, as I don't have a constant line : it's doign the same graphic as if I had only put the column "Result" in the value of the graphic in fact .

 

Thank you for your help!

 

 

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

4 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    HI 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

     

    • 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