topic Re: Avg of Column - Not Calculating Correctly in Desktop
https://community.powerbi.com/t5/Desktop/Avg-of-Column-Not-Calculating-Correctly/m-p/907695#M435024
<P><SPAN>Hi <LI-USER uid="150119"></LI-USER> </SPAN><SPAN>,</SPAN></P><P><SPAN>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 "<STRONG>working with individuals</STRONG>" 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 ?</SPAN></P><P align="left"><SPAN> </SPAN></P><P><SPAN>Best Regards</SPAN></P><P><SPAN>Rena</SPAN></P>Wed, 22 Jan 2020 09:25:50 GMTyingyinr2020-01-22T09:25:50ZAvg of Column - Not Calculating Correctly
https://community.powerbi.com/t5/Desktop/Avg-of-Column-Not-Calculating-Correctly/m-p/906915#M434661
<P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Working with Individuals.png" style="width: 999px;"><img src="https://community.powerbi.com/t5/image/serverpage/image-id/227682i6F5FEB3A3CD4B99E/image-size/large?v=v2&px=999" role="button" title="Working with Individuals.png" alt="Working with Individuals.png" /></span>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?</P>Tue, 21 Jan 2020 18:13:10 GMThttps://community.powerbi.com/t5/Desktop/Avg-of-Column-Not-Calculating-Correctly/m-p/906915#M434661jcastr022020-01-21T18:13:10ZRe: Avg of Column - Not Calculating Correctly
https://community.powerbi.com/t5/Desktop/Avg-of-Column-Not-Calculating-Correctly/m-p/906977#M434686
<P>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? </P><P>Is it possible to share your pbix? (you can share via PM if you don't want to share publicly).</P><P> </P><P>Kind regards</P><P>Djerro123</P><P>-------------------------------</P><P>If this answered your question, please <STRONG>mark it as the Solution</STRONG>. This also helps others to find what they are looking for.</P><P>Keep those <STRONG>thumbs up</STRONG> coming! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">ðŸ™‚</span></P>Tue, 21 Jan 2020 19:19:41 GMThttps://community.powerbi.com/t5/Desktop/Avg-of-Column-Not-Calculating-Correctly/m-p/906977#M434686JarroVGIT2020-01-21T19:19:41ZRe: Avg of Column - Not Calculating Correctly
https://community.powerbi.com/t5/Desktop/Avg-of-Column-Not-Calculating-Correctly/m-p/907017#M434705
<P>Is it dividing by the entire list of sttributes rather than just the one you have selected?</P>Tue, 21 Jan 2020 19:54:00 GMThttps://community.powerbi.com/t5/Desktop/Avg-of-Column-Not-Calculating-Correctly/m-p/907017#M434705Anonymous2020-01-21T19:54:00ZRe: Avg of Column - Not Calculating Correctly
https://community.powerbi.com/t5/Desktop/Avg-of-Column-Not-Calculating-Correctly/m-p/907695#M435024
<P><SPAN>Hi <LI-USER uid="150119"></LI-USER> </SPAN><SPAN>,</SPAN></P><P><SPAN>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 "<STRONG>working with individuals</STRONG>" 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 ?</SPAN></P><P align="left"><SPAN> </SPAN></P><P><SPAN>Best Regards</SPAN></P><P><SPAN>Rena</SPAN></P>Wed, 22 Jan 2020 09:25:50 GMThttps://community.powerbi.com/t5/Desktop/Avg-of-Column-Not-Calculating-Correctly/m-p/907695#M435024yingyinr2020-01-22T09:25:50Z