hi
attached is a table i created
the second measure is created by using this formula : {FIXED [CODE] : AVG([LowestPricePerCarat_Calc])}
now i want to create a number i can use in a different place, that will show me the average of this column in the table -
in my case - the average of 2229, 2126,2229,2229. the problem is when i am doing an average it shows me only the average of 2229, 2126 (since there are only 2 different {codes] ).
how can i get the average of all of the numbers ?
thank you!
10 answers
@Oren Yannai you'll just need to include your [#ID] field in the average calculation
See attached for reference 😊
I hope this helps!
Kelsie