Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago
Solved

Calculate Averages

Good evening, I hope you are well, I turn to you to consult the following:

I have this measure, which allows me to get sales totals for the years 2019, 2020, 2021.

Miguel_1979_0-1629764768578.png

the second measure allows me to get the sales averages for each year and month.

Miguel_1979_1-1629764825749.png

although when I create the model and place the measures in the matrix, it calculates the monthly averages, but in the final total throws another amount that is not the total of the average per month and year, I would like to know if you can help me to be able to clear this doubt, of why it does not calculate correctly, I remain attentive, mcuahs grcias.

Miguel_1979_2-1629764888270.png