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?
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 ?
Community Support Team _ Rena If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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).
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! 🙂
Did I answer your question? Mark my post as a solution!