Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
matdel
Helper I
Helper I

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]))

RM LIMS - Power BI Desktop.jpg

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!

 

 

1 ACCEPTED SOLUTION

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

4 REPLIES 4
Pragati11
Super User
Super User

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:

Pragati11_0-1619167124277.png

 

Thanks,

Pragati

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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]

 

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Thank you!! it works 🙂

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.