How to get the average of compliance in a table chart

[novieee]

Hello everyone, 

I was searching for solution for the past few hours but I cant find one, but if there is. Sorry for the inconvenience.

I am trying to get the average of OVWeeklySchedComp

 
I tried using AVERAGEX, and using the table 'LoadPlan', here are the formulas that I used

but the correct answer should be 57.56% and If I used the LoadPlan AVERAGEX the result is showing 53%.

Any help will do, thank you so much!

[novieee · Accepted solution]

Okay figured it out lol. The solution is easy, I was stuck here for like 3 hrs >.< 
here is the solution

[novieee]

Thanks for this post for enlightenment 
Solved: Re: Visualization table average - Microsoft Fabric Community

[novieee]

[novieee]

For proper context, I used Folder as my datasource, so it contains many excel files. That is why I have a formula for Name = "String" to make sure it will just get the data in that specific excel file if I changed the dates.

All data has been crossed check with the excel file, and its correct, its just that I cant get the average right ._.