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 just updated and confirmed this is on the Dec 2018 version of Power BI.
https://drive.google.com/file/d/1siXptcM3FGuvQ3VH4qbC3aBdgFUa0Dgl/view?usp=sharing
OK, I got it open.
I can't figure out why you want the average to be around 19. It looks correct as it is.
13.76/80.30 = 17.13%
How do you get the result you're expecting?