Skip to main content

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
0/9000