Forum Discussion
Simple Average
Hello! I have been using an AVERAGEX formula in power bi; however, I am noticing that this formula doesn’t work with breakdowns by category. I want to be able to take the average and divide it y total...
Hi,
I would like for my results below to total 19.06% instead of 27.24%. Since some months do not have values my formula is excluding those records. In this case it would be divided by 10 because there are only 10 months but it will change every month depending on the months selected. For instance next month it will be 12 months of data even if all months do not have values I need the data to divide by the full 12 months for the average.
Current formula:
AVG_Category_Breakdown =
AVERAGEX(SUMMARIZE(VALUES('download to use'[Month]),[Month],"ABCD",[Category_Breakdown]),[ABCD])
I would like for my results below to total 19.06% instead of 27.24%. Since some months do not have values my formula is excluding those records. In this case it would be divided by 10 because there are only 10 months but it will change every month depending on the months selected. For instance next month it will be 12 months of data even if all months do not have values I need the data to divide by the full 12 months for the average.
Current formula:
AVG_Category_Breakdown =
AVERAGEX(SUMMARIZE(VALUES('download to use'[Month]),[Month],"ABCD",[Category_Breakdown]),[ABCD])
Let me explain.
Category_Breakdown ties to Total_Score and that is correct. However, the Category_Breakdown2 (the formula you shared) is giving me the same results as Category_Breakdown. However, I need this to be the same for the new AVG formula that I am leveraging.
I think this all has something to do with the AVG formula that I am using to simply get a straight average. I need my percentage breakdown to work using a similar functionality. I need the breakdown to also be a simple AVG.
Category_Breakdown ties to Total_Score and that is correct. However, the Category_Breakdown2 (the formula you shared) is giving me the same results as Category_Breakdown. However, I need this to be the same for the new AVG formula that I am leveraging.
I think this all has something to do with the AVG formula that I am using to simply get a straight average. I need my percentage breakdown to work using a similar functionality. I need the breakdown to also be a simple AVG.
nmck86,
I am not clear about your expected result. Could you please elaborate more about the desired result based on the PBIX file?
Regards,
Lydia- Sure, I am expecting my values for mad customers to add up to an average of 19.06 instead of what it is currently displaying. I want it to add all months instead of only the ones with values. In this case it would be a divide by 10 months since in this case the data only goes through October.