Forum Discussion
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 I ultimately want, is to use the values in the measure "averge score per publish date" to calulcate the average score per month.
Here's a table as an example
| ID | Score | Publish Date | Month |
| 1 | 90 | 9/14/2022 | September |
| 1 | 60 | 9/14/2022 | September |
| 1 | 75 | 9/15/2022 | September |
| 1 | 85 | 9/15/2022 | September |
What I want but do not know how to do.
Step 1. Averge score per publish date 9/14/2022
90+60 = 150/2= 75
Step 2. Average score per publish date 9/15/2022
85+75= 160/2 = 80
Step 3. Average score per month. ( using average score per publish date to calculate)
80+75= 155/2 = 77.5
What I know how to do but do not want.
Step 1. Average score per month( using scores to caluclate)
90+60+85+75 = 77.5
Here is also the DAX formula that I used to get the average score per publish date.
Try:
Average by month = AVERAGEX(VALUES(Table[Month]), [Average Score Per Publish Date])
1 Reply
PaulDBrownCommunity Champion
Try:
Average by month = AVERAGEX(VALUES(Table[Month]), [Average Score Per Publish Date])