Forum Discussion

cristianml's avatar
cristianml
Post Prodigy
4 years ago
Solved

Average from a column

Hi,

 I need help in order to get an average of values from a table. In this case I need to get to 292 that is the avg of the following numbers:

 

 

 

I tried the following measure but it doesn't work.

__00_AVG REV = AVERAGEX(VALUES('Rev Seq Database'[Type of Work]),AVERAGE('Rev Seq Database'[Value]))

 

Any idea?

 

 

 

  • Hi cristianml 

     

    You can try the following measure:

     

    Avg Rev = AVERAGE ( 'Table'[Revenue] )

     

    Hope this helps!

    Theo 🙂

     

4 Replies

  • TheoC's avatar
    TheoC
    Community Champion

    Hi cristianml 

     

    You can try the following measure:

     

    Avg Rev = AVERAGE ( 'Table'[Revenue] )

     

    Hope this helps!

    Theo 🙂

     

      • TheoC's avatar
        TheoC
        Community Champion

        Hi cristianml  is your __REV that you have in your original post a column or measure?