Forum Discussion

cristianml's avatar
cristianml
Icon for Post Prodigy rankPost 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?

 

 

 

data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • TheoC's avatar
    TheoC
    4 years ago

    Hi cristianml 

     

    You can try the following measure:

     

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

     

    Hope this helps!

    Theo 🙂

     

4 Replies

  • TheoC's avatar
    TheoC
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi cristianml 

     

    You can try the following measure:

     

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

     

    Hope this helps!

    Theo 🙂

     

    • cristianml's avatar
      cristianml
      Icon for Post Prodigy rankPost Prodigy
      4 years ago

      Hi TheoC ,

       

      That was the first thing I did. But It doesn't work.

       

       

      • TheoC's avatar
        TheoC
        Icon for Community Champion rankCommunity Champion
        4 years ago

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