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...
I want the average to be a straight divide by the months so in this case it would be a straight divide by 12. It wouldn’t be 19.06 in this example it would be less. But if I selected on Jan-Oct it would be 19.06 or close to it. I need the calculation to do a straight average divided by each month. If we are looking at only Jan, Feb & March for instance and I select a filter for those months I would expect the average to be 13.06%.
I still don't understand what "straight divide by the months" means. What number are you dividing by 12?
Can you show the calculation for how you are getting 19.06% or 13.06% from the underlying column?