Forum Discussion
pakovic
Helper I
Helper ICalculating 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...
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
pakovicHelper I
Helper IBut, is correct 22,70 or 23,52 ? I think the correct is 23,52
amitchandak
Super User
Super Userpakovic , 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