Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Average per day with multiple values each day

Hi,
I am doing a report where I would like to get the average for each day. 

The issue I am facing is that there is multiple values on each day which is making the average much lower than expected. 

 

The table contains one row per pause. First of all it needs to be sum of duration per day since it is multiple values each day.
Then I need to get an average per week (existing relatonship with a date table). When I am doing the average right now I am getting a very low average since it is calculating the average per row and not sum per day per membername.

 

 

 

 

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Please refer to my pbix to see if it helps you.

    The relationship between the tables.

     

    Then create a measure.

     

    Measure = CALCULATE(AVERAGE('Table'[DURATION_Seconds]),FILTER(ALL('Table'),'Table'[date]=SELECTEDVALUE('Table 2'[Date])))

     

     

     Could you tell that you want to calculate Average per day or Average per week?

     

    If I have misunderstood your meaning, please provide your desired output and your pbix file without privacy information.

     

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies