Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX to average a measure?

I have a table with the columns "ID" ,"month" , "score" and "publish date". I have a measure that gets me the "average score per publish date" and then I just filter by ID on my report page.   What...
Tips and Tricks
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Try:

    Average by month = AVERAGEX(VALUES(Table[Month]), [Average Score Per Publish Date])

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

Try:

Average by month = AVERAGEX(VALUES(Table[Month]), [Average Score Per Publish Date])