Weighted Average

Hey czuniga ,

the following measure should fulfil your criteria:

Average if not paid or 30 days =
CALCULATE(
    AVERAGE( myTable[# Of Days Between Date Submitted & DatePaid OR # Of Days Since Submitted] ),
    FILTER(
        myTable,
        myTable[Date Paid] = BLANK() || DATEDIFF( myTable[Date Paid], TODAY(), DAY ) <= 30
    )
)