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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Kolumam
Post Prodigy
Post Prodigy

Average of a calculated column

Hi All, I have a calculated column. I am trying to find the average of the yield using a measure but when I do the average I get the same values instead of a constant value at every row. Please help.

dfs.JPG

1 ACCEPTED SOLUTION

Hi @Kolumam ,

Normally, the formula of Ashish_Mathur should work.

Capture.PNG

So if you have not solved your problem, please share your data sample so that we could help further on it.

If you sloved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

8 REPLIES 8
Ashish_Mathur
Super User
Super User

Hi,

 

Share a simple dataset that can be pasted in MS Excel and show the expected result there.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi,

 

Expected result in 4th column. Please note the 3rd column in my table is a calculated column.

 

ffffff.JPG

Hi,

 

If you want a simple average of the values lying in the Yield column, then write this measure

 

=CALCULATE(AVERAGE(Data[Yield]),ALL(Data[Meter Reading]))

 

If this does not help, then share the link from where i can download your file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi

 

I tried your formula and I am getting the below error.

Capture.JPGfgg.JPG

Hi @Kolumam ,

Normally, the formula of Ashish_Mathur should work.

Capture.PNG

So if you have not solved your problem, please share your data sample so that we could help further on it.

If you sloved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

How do I get the number that appears in the totals row of the measure column to appear on the card? I get some other number instead and I don't know where it's coming from.

Hi,

Share some data, describe the question and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

aShare the link from where i can download your file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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