Average line value produce different result with Card average

[Anonymous]

I plotted a line chart and I use the 'Average Line'. Based on the figure, it shows the average is 6.

I also calculate the average using Card but I am getting different value of average which is 3.97.

Can someone explain why? And which one is accurate?

 

Also, Median produces different value as well..

[adleh]

I am having the same issue, is there a solution to this?

[v-yingjl]

Hi @Anonymous ,

I have tested in my environment but it seems work fine that the value in average line and median line are the same as the value in the card. Both of them have also applied same filters.

Have you set the field in Y-axis in line chart as the same as in the card? The field count represent what and what is the data category of it? Usually, if the field is a sigma value, it should show the same value both in line chart and cards. Could you please consider provide a dummy .pbix file for further discussion?

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , This what I can think of. That Average line is based on the plotted Axis(Grouped) . Means data first grouped at axis level and Average is taken, while you have taken a simple average.

Check like this

averagex(Summmarize(Table,Table[Date],"_Avg",[Line measure]),[_Avg])

Replace Table[Date] with the field on-axis

Replace [Line measure] with measure used for line

Check if two give the same value.

[Anonymous]

Sorry,

How can I get [Line Measure]? Because I'm using the one in Analytics to plot the average line.

[Greg_Deckler]

Well, MEDIAN is very different from AVERAGE. A median is the number where half the numbers in a set are below and half above. AVERAGE is the sum of the numbers in the set divided by the count. Two very different things.

As for what you are seeing, very difficult to say. Is the line the value of Count? Are there different filters on the visuals?

[Anonymous]

same filter applied for both..