Assuming you want to compute this average within every row of your data, this should get you to the answer you want.
AVG ( [Measure 1] + [Measure 2] )
Hope this helps,
I'm still not getting the desired result... I do want to compute the average within every row, yes. But this is not giving me the result I'm looking for.... "AVG ( [Measure 1] + [Measure 2] )" gives me a new column which is the two values added together.
As an example. I have a row where the two values are 0.354963 and 0.204312
The formula you provided gives me the sum of those two values (0.55927484) When I am looking for 0.279637
Any other ideas?
That is my mistake. What about just creating a calculation that is simply (Measure 1 + Measure 2) / 2 . This should be what you need. Sorry about my misunderstanding earlier.
Yes, I figured that out minutes after posting my followup question and felt very dim.
THANK YOU for your help!
No worries. It happened to me as well . Also no such thing as a silly question on here. We are all glad to help out.