Forum Discussion
Post ProdigyAvg of Column - Not Calculating Correctly
I am trying to do a simple visualization with the average of each of the values for each attribute. I noticed that when I filter my data for working with individuals, the total is 5.4 and dividing that by 18, I should show 30% and my visual is showing 18%? Can you see what I may be doing incorrectly?
3 Replies
- JarroVGIT
Resident Rockstar
Hmm is it just me or are you having 22 rows? Manually calculating results in an average value of 0.2454 so I expect there is something other funny business going on in your dataset. I see for example a lot of errors in you Value column?
Is it possible to share your pbix? (you can share via PM if you don't want to share publicly).
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Hi jcastr02 ,
You are using stacked bar chart visual according to the screenshot you provided , where the average value are calculated by dividing the total value of each category by the amount of that category. For example , calculate the average value of "working with individuals" data in your scenario , the total value of this category is 5.4 , assuming that the amount of this category is 18 , then the average value should be 0.3 (5.4/18 ) . As for why the value you got is incorrect , I'm not sure if is caused by the data or some filters applied affect the calculation result . If it is convenient , could you please provide your PBIX file with sample data ?
Best Regards
Rena
