// Engineering Information Performance Lab — illustrative DAX measures
// Designed for a star model with FactInformationEvent and DimDate / DimPackage / DimDiscipline.

Open Items :=
CALCULATE(
    COUNTROWS(FactInformationEvent),
    FactInformationEvent[status] = "Open"
)

Open RFIs :=
CALCULATE(
    [Open Items],
    FactInformationEvent[record_type] = "RFI"
)

Overdue Open Items :=
CALCULATE(
    COUNTROWS(FactInformationEvent),
    FactInformationEvent[status] = "Open",
    FactInformationEvent[due_date] < TODAY()
)

Median Closed Cycle Days :=
MEDIANX(
    FILTER(FactInformationEvent, FactInformationEvent[status] <> "Open"),
    FactInformationEvent[cycle_days]
)

First Pass Approval % :=
DIVIDE(
    CALCULATE(
        COUNTROWS(FactInformationEvent),
        FactInformationEvent[record_type] = "SUBMITTAL",
        FactInformationEvent[first_pass_approved] = TRUE()
    ),
    CALCULATE(
        COUNTROWS(FactInformationEvent),
        FactInformationEvent[record_type] = "SUBMITTAL"
    )
)

Open Item Age Days :=
VAR CreatedDate = MAX(FactInformationEvent[created_date])
RETURN DATEDIFF(CreatedDate, TODAY(), DAY)