Forum Discussion
How to create measures that keep steady value
I am working on creating a control chart to show average cost each month in the past 12 months. I have created a Line Chart visual with month on the x-axis and average cost per month on the y-axis. O...
- Hi Anonymous,
You need to do a measure similar to this
Total average = CALCULATE (AVERAGE(Table[Total Cost]) ; ALL(Table[Month]))
MFelix
Super User
Super UserHi Anonymous,
You need to do a measure similar to this
Total average = CALCULATE (AVERAGE(Table[Total Cost]) ; ALL(Table[Month]))
You need to do a measure similar to this
Total average = CALCULATE (AVERAGE(Table[Total Cost]) ; ALL(Table[Month]))