I have a visual that shows the average hours worked on certain services per week. On the whole, this visual / formula works exactly as I like it to - Except - what I would like is when all sessions are selected, it seems to just divide the total hours worked/by the total number of weeks, which for all-sessions - is not correct.
Anyone have any ideas?
Here is the formula:
Solved! Go to Solution.
May I ask whether your problem has been solved, if so, can you consider sharing your solution,and then mark your post as Answered since it is working now? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.
Hello - yes - another person was able to help build a separate table within the file and that is how they were able to work around it. Let me know if that helps?
When you check box "Select all" it is like you are including values from blank rows in your model. it is better not to use select all and keep the boxes unchecked( it is doing the same thing as you check box all of them.
But I'd like it to show 'all weeks' from 'all sessions' as well to display the overall average from the time that we started this, but is there a way to write the formula to show that when they are all checked?
Here is a quick example:
As you can see the 74 Blank rows are not included in the calculation of number of days.
do the same for your avarage formula where ever is neccessary.
I do not have any blank lines, as when each session is selected by itself - it works correctly - but when all sessions are selected (along with all weeks), I want it to show the average of all sessions.
Sorry if I am not understanding correctly?
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps