How to get technician ticket count by day/week/month making sure a five day week is accounted for

[Anonymous]

Hello everyone - I am a somewhat newbie at PowerBi. I haver a dashboard that shows the average ticket resolved count for our employees. RIght now the average is based out of the tickets resolved divied by the dates within that week. I would like to average out the tickets to a full five day business week and exclude holidays. Can anyone suggest how to make sure the average is based out of a five day business week exclude holidays? Appreciate any assistance. Thanks

[v-yuta-msft · Accepted solution]

@Anonymous,

I'm afraid you should create a seperate holiday table which contains all of the holidays and weekends date. Than use DAX like pattern below:

Result =
CALCULATE (
    AVERAGE ( Table[Value] ),
    FILTER ( Table, Table[Date] IN VALUES ( Holiday_Table[Date] ) )
)

Community Support Team _ Jimmy Tao

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

[Greg_Deckler]

Take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365