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 GilbertQ,

 

Thanks for the workaround, I got the same value on the Average Line by creating a measure as (Measure = SUM('TREP_0426 updatestotalRatePerSe'[Update Rate]))  and select this measure when adding Average Line.

GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi liping_qin

 

What if you change the measure from a SUM to an AVERAGE?

  • liping_qin's avatar
    liping_qin
    New Member
    9 years ago

    Hi GilbertQ,

     

    This time I got an average line of value 137, still not the expected 140.10, not sure what's wrong with the Average Line function.

     

    And here's the sample data you could used to reproduce the issue.  

     

    https://1drv.ms/u/s!Auczg22cCvWx1wlvMZJGet7EOFz1 

     

    We tried a sample of 20 data points with one point's value as 0, the value of Average Line is the same as that calculated by Excel Average function.

     

    Not sure if our issue is caused by large number of data points.