Forum Discussion
Solved
average line
As could be seen from the screenshot, the value of an average line (232, the red line) is not the same as the average value on a table (140.10, on the top right), with the same data set of 448968 ...
What you could do is to create the following measure which will then create the line across your dataset
Average Line = CALCULATE ( DIVIDE ( SUM ( '0426'[Update Rate] ), COUNTROWS ( '0426' ) ), ALL ( '0426' ) )And here is what it looks like once completed
And here is the updated file here: https://1drv.ms/u/s!Apxn-69XhcAmhqsVDkaulZTJN9sztA
