Calls per day of week name

[craigmon]

Hi Guys,

I have the below table.  I'm trying to calculate a simple average.  I would like to display the average amount of calls offered per DayofWeekName.  The result table would just show Mon to Friday and the average calls offered for that of the week, based on the Month Year selected from the slicer.

Hope this makes sense

Thanks

Queue	DayOfWeekName	Month Year	Calls Offered
Queue 1	Wednesday	2021-03	2
Queue 2	Sunday	2021-03	2
Queue 3	Wednesday	2021-03	2
Queue 4	Friday	2021-03	2
Queue 5	Tuesday	2021-03	2
Queue 6	Tuesday	2021-03	2
Queue 7	Monday	2021-03	2
Queue 8	Sunday	2021-03	2
Queue 9	Saturday	2021-03	2
Queue 5	Tuesday	2021-03	2
Queue 7	Saturday	2021-03	2
Queue 6	Saturday	2021-03	2
Queue 6	Friday	2021-03	2
Queue 4	Friday	2021-03	2
Queue 4	Friday	2021-03	2
Queue 5	Tuesday	2021-03	2
Queue 9	Monday	2021-03	3
Queue 7	Saturday	2021-03	2
Queue 4	Monday	2021-03	2
Queue 6	Thursday	2021-03	2
Queue 3	Wednesday	2021-03	2
Queue 4	Monday	2021-03	3
Queue 6	Saturday	2021-03	3
Queue 10	Saturday	2021-03	3
Queue 3	Monday	2021-03	3
Queue 6	Friday	2021-03	3
Queue 3	Friday	2021-03	3
Queue 6	Monday	2021-03	3
Queue 11	Monday	2021-03	3
Queue 12	Monday	2021-03	3
Queue 3	Wednesday	2021-03	3
Queue 3	Wednesday	2021-03	3
Queue 4	Tuesday	2021-03	3
Queue 3	Monday	2021-03	3
Queue 6	Monday	2021-03	3
Queue 3	Wednesday	2021-03	4
Queue 11	Thursday	2021-03	4

[Icey]

Hi @craigmon ,

Can't this work for your scenario?

Best Regards,

Icey

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

[truptis]

Hi @craigmon , Try this:
Calls = COUNTROWS(SUMMARIZE(Calls,Calls[DayOfWeekName],Calls[Calls]))

[craigmon]

Thanks, I've used the below but I'm getting very low results

01 Calls = COUNTROWS(SUMMARIZE(Query1, Query1[DayOfWeekName], Query1[QueueOffered]))

[amitchandak]

@craigmon , I think you should sum up

example

01 Calls = Averagex(SUMMARIZE(Query1, Query1[DayOfWeekName],"_1" , Sum(Query1[QueueOffered])), [_1])