Averages Slightly Off

[i820017]

I have data in an excel file that was exported from a Power BI Report from February 2023 as seen below.

When I calculate the Avg Score % by hand then I get an average = 95.00%

Each individual Average is calculated the DAX formula Score%5 (which is spelled out at the bottom)

However, when I take this same data, and make it into a bar chart, then I get an Avg of 94.53% as seen below

Here is the DAX Formula that yields 94.53% instead of 95.00%

Score%5 =

var Sales1    = AVERAGEX(SUMMARIZE (ININ,ININ[EmpID],ININ[RecordingDate]), CALCULATE(AVERAGEX(VALUES(ININ[EmpID]),DIVIDE(sum(ININ[AnswerScore]),sum(ININ[QuestionMaxScore])))))

var Service1  = AVERAGEX(SUMMARIZE (ININ,ININ[EmpID],ININ[RecordingDate]), DIVIDE(CALCULATE(AVERAGEX(VALUES(ININ[EmpID]),AVERAGE(ININ[Score]))),100))

return IF(Sales1 > Service1, Sales1, Service1)

Any idea on why I am getting 94.53% instead of 95.00%?

[Greg_Deckler]

@i820017 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.