Forum Discussion
Call Centre Daily Occupancy
Thanks v-kelly-msft, I appreciate the time you've spent helping with this. Unfortunately on my live data your measure works for each day but doesn't give a correct figure when the filter is for more than one day. If I apply this to my whole dataset I get a total occupancy of 254%, which is correct in that we see a total of 61 unique users over the ~year period (and 61/24 = 2.54), but is incorrect as I need to calculate the total as an average of the daily %.
I realise that my initial question was too limited for what I am trying to achieve.
I hope that makes sense, I've tried to modify what you've posted but I haven't been able to get it to work. The closest I got was based on another post on this forum, I got
I played around with a MIN value in the filter but it didn't seem to affect anything 'MIN ( agent_log_sanitised[callDate] ) = [callDate]'
My other thought was to create a new table in the model and calculate users per call day and then reference that in a DAX query but this seems overly complicated?
I've attached to my original post an updated copy of the PBIX you kindly provided with a version of my actual data and several attempts at getting the occupancy data to work. If you can spare a moment to have another look I would be very grateful.
Hi MrPatrick ,
After checking your .pbix file,I'm a little confused about what you're expecting for?As in the year of 2019,there're 61 users in your table,so if you wanna calculate a summarized data of the whole year,it should be 61/24*100,and the result must be over 100%.
So I'm wondering if you wanna get a result as below? The measure marked in red?
If so,you only need to use an average function to calculate in
Measure = AVERAGE('CalculatedOccupancyData'[Column1])
Hope this would help.
Best Regards,
Kelly