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...
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.