Forum Discussion
Solved
Single figure for average measure
This is my data (example): For each yearmo I want to get the sum of the score. I then want to get the average of those sums. I have been able to achieve this using AVERAGEX as per below: ...
Try creating a new measure like this:
CALCULATE([Average of sums],REMOVEFILTERS('Scores Table'[yearmo]))
And add that to the line chart. I hope this helps.
Use line and clustered column chart. On clusters use values "sum of score", on line use "Average of sums" metric
This doesn't achieve the desired result as the line for "Average of sums" differs for each yearmo:
I want to be able to show a constant line at 1.37 in this case
- dk_dk
Super User
Try creating a new measure like this:
CALCULATE([Average of sums],REMOVEFILTERS('Scores Table'[yearmo]))
And add that to the line chart. I hope this helps.