Forum Discussion

pakovic's avatar
pakovic
Helper I
4 years ago
Solved

Calculating the average in the graphs

In this example the accumulated per month is calculated and the line values are the average per month of Euros/Litres, but this average is different in one graph and in the other. For example in Nove...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    pakovic , A per me

    22.70 coming from divide(sum(Table[Euros]), sum(Table[Litres]))

     

    the other one is

    averageX(Values(table[Product]), calculate(divide(sum(Table[Euros]), sum(Table[Litres]))  ))

    // Avg of rows

amitchandak's avatar
amitchandak
Super User
4 years ago

pakovic , That is a simple average,

In the latest version, You have fx option under the Constant line( Y axis constant line) , Use that and give this measure, you should get correct value