Forum Discussion
simple_AVG_formula
Ashish_Mathur Hi Ashish did you have any thoughts on how I could make this work? I am open to alternatives if the AVERAGE(SUMMARIZE dax may not would work.
Your question is not clear to me. That is why i did not contribute.
Ashish_Mathur v-jiascu-msft I am hoping to get my average category breakdown amounts happy customers 71.35% and mad customers 27.24% to equal my average 52.28%. Basically the average function is disregarding months with no values. I want my calculation to do a straight average over the months selected. For instance, Jan-October I want an average over all 10 months even if a few months do not have values. See below the mad customers does not have a value for every month so it is bringing in a percentage of 27.24 which is the avg of the months with values and it is excluding any month that doesn't currently have a value. Hope this makes more sense for sure!
Ashish_Mathur this seems very close to what you did here in this post https://community.powerbi.com/t5/Desktop/including-blanks-in-an-average-with-summarize/td-p/332922
I tried to use that function but it didn't work for me.