Sum Items on business days only

[Coryanthony]

Hello,

I need help totalling [Line Items Audited] but on business days only. My goal is to get the average Line Items Audited per business day in the month. 

So for October, if I audited 2000 line items on business days only and there was 21 business days - Average would be 95.24.

Line Items Audited = CALCULATE([Line Items Actioned], 'All Actioned'[Selected for Audit] = 1) +0

calendar_Workdays = NETWORKDAYS(MIN('Calendar'[Date]), MAX('Calendar'[Date]), 1, ALL(Holidays[Date] ))

[Fowmy]

@Coryanthony 

Is this what you are looking for?

New MEASURE = 

DIVIDE (
    [Line Items Audited],
    [calendar_Workdays]
)
    

[Coryanthony]

Hi @Fowmy 

We first need to calculate [line items audited] that occurred on business days only (excluding weekend and holidays ). 

[Fowmy]

@Coryanthony 

Line Items Audited  =
CALCULATE (
    [Line Items Actioned],
    'All Actioned'[Selected for Audit] = 1,
    NETWORKDAYS (
        MIN ( 'Calendar'[Date] ),
        MAX ( 'Calendar'[Date] ),
        1,
        ALL ( Holidays[Date] )
    )
)

[MotazOdeh757]

I need your help guys to export PDF report or PPT for my Power Bi Dashboard note that my user is pro and i dont want to update it to premium and to be sent automatically via power automate, export automatically send email to specific recipient automatically