Forum Discussion
Solved
Help with Dax Formula - Average Hours Per Week Visual Assistance
Hello, 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 a...
Power bi reports are treated case by case, so maybe a sample Pbix would be a better idea so i can work on it and help you understand.
I'm still learning - how would that look?
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 bi reports are treated case by case, so maybe a sample Pbix would be a better idea so i can work on it and help you understand.