Creating measures based on different deadline dates

Hi PaisleyPrince 

1. Department Deadline Table (Dimension)

Create a separate table (or import one):

Department DeadlineDay

Department 1 7
Department 2 14

➡ DeadlineDay = day of month

Relate:

Invoices[Department] → DepartmentDeadline[Department]

2. Invoice Fact Table (Minimum Fields Needed)
InvoiceID Department PostingDate

Key DAX Measures
Total Invoices
a)Total Invoices :=
COUNT ( Invoices[InvoiceID] )

Invoices Posted (On or Before Deadline)
b)Invoices Posted =
VAR Deadline =
MAX ( DepartmentDeadline[DeadlineDay] )
VAR CurrentMonth =
MAX ( MONTH ( Invoices[PostingDate] ) )
VAR CurrentYear =
MAX ( YEAR ( Invoices[PostingDate] ) )

VAR DeadlineDate =
DATE ( CurrentYear, CurrentMonth, Deadline )

RETURN
CALCULATE (
COUNT ( Invoices[InvoiceID] ),
Invoices[PostingDate] <= DeadlineDate
)

Invoices Not Posted (After Deadline)
c)Invoices Not Posted :=
[Total Invoices] - [Invoices Posted]