topic Re: How to get the average of compliance in a table chart in DAX Commands and Tips

How to get the average of compliance in a table chart

novieee — Wed, 28 Jun 2023 07:15:40 GMT

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!

Re: How to get the average of compliance in a table chart

novieee — Wed, 28 Jun 2023 07:41:21 GMT

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 ._.

Re: How to get the average of compliance in a table chart

novieee — Wed, 28 Jun 2023 07:51:37 GMT

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

Re: How to get the average of compliance in a table chart

novieee — Wed, 28 Jun 2023 07:52:59 GMT

Re: How to get the average of compliance in a table chart

novieee — Wed, 28 Jun 2023 07:57:38 GMT

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