Forum Discussion
Help with Dax Formula - Average Hours Per Week Visual Assistance
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.
Hi ianallen13
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?
Embed your formula into a CALCULATE function and filter out the blank rows.
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.