Calculate Averages

[Syndicate_Admin]

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.

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

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.

[VahidDM · Accepted solution]

Hi @Syndicate_Admin 

This looks like a measure totals problem. See Greg_Deckler posts about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!