OK, so the top visual is correct then? And in the bottom visual, you want to see the AVERAGE per day for each hour for the selected date range in the slicer above? Are those all correct statements?
If those are all correct statements, you could do a COUNTROWS of your calendar table (if your slicer is based upon that) and use that as your denominator.
Proud to be a Super User!
View solution in original post
Yes, the top visual is correct, and yes, those are all correct statements.
I think that worked! I'm testing now. Thank you! I'll mark it as the answer, once I'm done with my testing. I appreciate it!!
Thanks for your help! I believe that solved it. I've been testing it, and it looks good.
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.