Forum Discussion

liping_qin's avatar
liping_qin
New Member
9 years ago
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 ...
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    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

liping_qin's avatar
liping_qin
New Member
9 years ago

Hi Ross, 

 

Thanks very much for helping here. I tried to attached the sample dataset, but didn't find where to attach.

We didn't write Dax code, but import a excel dataset and drag and draw the charts.  Here's the setting, the first one for the value on Table, and second one for the Average Line on Line Chart.

 

GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi liping_qin

 

Could you perhaps create a new measure which will be the Sum of your data.


Then when you create your Average Line, from the Measure drop down, select the average measure you just created.