Forum Discussion

ianallen13's avatar
ianallen13
Helper I
5 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • aj1973's avatar
    aj1973
    5 years ago

    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.

     

ianallen13's avatar
ianallen13
Helper I
5 years ago

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?  

aj1973's avatar
aj1973
Community Champion
5 years ago

Embed your formula into a CALCULATE function and filter out the blank rows.

 

  • ianallen13's avatar
    ianallen13
    Helper I
    5 years ago

    I'm still learning - how would that look? 

    • aj1973's avatar
      aj1973
      Community Champion
      5 years ago

      ianallen13 

      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.

       

      • ianallen13's avatar
        ianallen13
        Helper I
        5 years ago

        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?