Forum Discussion
sshaw10
3 years agoNew Member
Line graph with cut off point for average line
Hi. I'm working on an area chart that contains defect counts and a static average of the defect counts. I was able to create a measure that produces a static average line. Now, I want to have the average line cut off to the current month and update when new data is refreshed each month.
Current measure to get average line:
Average =
CALCULATE ( COUNTROWS('Table Data'), ALLEXCEPT( 'Calendar','Calendar'[Year] ) )
/[Static Month_number]
Any ideas on how to update my current measure to get an average line that cuts off to the current data? (being sept in this case). Thanks.
sshaw10 , Try this measure for line
Averagex(Values(Date[Month Year]), calculate(COUNTROWS('Table Data')))
2 Replies
- amitchandak
Super User
sshaw10 , Try this measure for line
Averagex(Values(Date[Month Year]), calculate(COUNTROWS('Table Data')))
- sshaw10New Member
Thanks amitchandak That measure did the job!