Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
Hi,
Share a simple dataset that can be pasted in MS Excel and show the expected result there.
Hi,
Expected result in 4th column. Please note the 3rd column in my table is a calculated column.
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.
Hi
I tried your formula and I am getting the below error.
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
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.
aShare the link from where i can download your file.