Forum Discussion
Solved
Straight Mean Line
HI All,
I know in the Clustered Column Chart, we can easily show the Average Line from the Analytics.
For me I'm using the Line and Clustered Column Chart to show the data by Month as Column Bar and Cumulative sum according to Month using the Line. Since there is no Analytics for this kind of Chart, how can I measure the Average/ Mean for this?
Thanks.
MSS_ You need create a measure and use that in line
example
calculate([Measure], allselected() )
calculate(Averagex(Values(Date[Month])[Measure]) , allselected() )
1 Reply
MSS_ You need create a measure and use that in line
example
calculate([Measure], allselected() )
calculate(Averagex(Values(Date[Month])[Measure]) , allselected() )