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 bu...
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 🙂

     

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?

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

      cristianml below is the output when you have a column with the average as per your post.  If your data model isn't established as per the post, more detail is needed so that the right solution can be provided. Output below from the AVERAGE measure: