Excel total average value different than Power Bi

[Anonymous]

If you add these 5 percentages and divide by 5 you will get 11.016

I need to count the rows with 0%  (or even blank values) so that is why I am counting the 0% rows  (in these cases the discount is 0).  

What my users are expecting is that the total average at the bottom of the column is indeed the average of those 5 values.   But Power Bi is showing something different.  

Trying to understand how to fix this?    There is no measure being used on that average column...it is just using the selction available to show the average versus showing the sum etc.  

[DataInsights]

@Anonymous,

I'm not able to reproduce the issue. Would you be able to provide a link to the pbix? Here's what I'm getting: