Forum Discussion
simple_AVG_formula
Hello,
I am running into an issue trying to get a simple avg formula to work inside Power BI for this particular case. In the image below you will notice that I have a category breakdown and then to the right I have the total score and total score average. The total score and the average are correct; however, the average I am getting for the category breakdown is wrong. I am expecting the HAPPY CUSTOMERS - MAD CUSTOMERS TO EQUAL 52.28% and it is way off from that. I am sharing the link to the pbix if anyone can assist.
https://drive.google.com/open?id=1siXptcM3FGuvQ3VH4qbC3aBdgFUa0Dgl
8 Replies
OwenAuger Anonymous Ashish_Mathur this has a link to it so you can see the data as it is currently. Let me know if you can assist with it through the pbix file shared.
Hi,
Try this measure
=Category_Breakdown = if(HASONEVALUE('download to use'[Category]),DIVIDE([WT],CALCULATE([WT],ALL('download to use'[Category]))),[avg])
Hope this helps.
HI Ashish_Mathur Anonymous and OwenAuger v-jiascu-msft unfortunately that does not work. In this situation I am getting the same result as I had originally.
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. When I do the math of happy-mad I expect Category_Breakdown to tie to Total_Score and it does! However, I need this to be the same for the new AVG formula that I am leveraging. I need my AVG formula to tie back to the Category Breakdown2; however, it doesn't. Essentially, I need my happy-mad=avg.
Let me know something happens to not make sense!
