Average of a calculated column

[Kolumam]

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.

[Ashish_Mathur]

Hi,

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

[Kolumam]

Hi,

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

[Ashish_Mathur]

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.

[Kolumam]

Hi

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

[v-piga-msft · Accepted solution]

Hi @Kolumam ,

Normally, the formula of Ashish_Mathur should work.

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

[Anonymous]

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.

[Ashish_Mathur]

Hi,

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

[Ashish_Mathur]

aShare the link from where i can download your file.