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