Calculate avg date difference in network days only for companies with start and end dates.

[SamK428113]

I am trying to calculate the average of network days for non blanks between Start and End dates. However, when I try to get the average number of networkdays in a given column, the value returns as blank.  Below are the measures I'm using.

Test 10 =

VAR _a =

    CALCULATE(

        MIN('CWMT_MS_QUOTINGREQUESTTRACKER - Master'[TIME_STAMP]),

        FILTER(ALL('CWMT_MS_QUOTINGREQUESTTRACKER - Master'),

        [COMPANYNAME] = SELECTEDVALUE('CWMT_MS_QUOTINGREQUESTTRACKER - Master'[COMPANYNAME])

        && 'CWMT_MS_QUOTINGREQUESTTRACKER - Master'[TASKNAME] = "110 - Attach NPS Packets to Quotes"

        && 'CWMT_MS_QUOTINGREQUESTTRACKER - Master'[TASKSTATUS] = "Assigned"))

Var _b =

    CALCULATE(

        MAX('CWMT_MS_QUOTINGREQUESTTRACKER - Master'[TIME_STAMP]),

        FILTER(ALL('CWMT_MS_QUOTINGREQUESTTRACKER - Master'),

        [COMPANYNAME] = SELECTEDVALUE('CWMT_MS_QUOTINGREQUESTTRACKER - Master'[COMPANYNAME])

        && 'CWMT_MS_QUOTINGREQUESTTRACKER - Master'[TASKNAME] = "510 - Generate Customer Package"

        && 'CWMT_MS_QUOTINGREQUESTTRACKER - Master'[TASKSTATUS] = "Completed"))

RETURN

     if (

    ISBLANK([Test 110 Assigned])||ISBLANK([Test 510 Completed]),

    BLANK(),

    NETWORKDAYS([Test 110 Assigned],[Test 510 Completed]))

Test 4 = AVERAGEX('CWMT_MS_QUOTINGREQUESTTRACKER - Master', [Test 10])

Test 4 returns as (Blank).

Any idea why the value is showing blank?

For calendar days, I'm using this measure and it seems to be working...

Test 9 =

VAR _a =

    CALCULATE(

        MIN('CWMT_MS_QUOTINGREQUESTTRACKER - Master'[TIME_STAMP]),

        FILTER(ALL('CWMT_MS_QUOTINGREQUESTTRACKER - Master'),

        [COMPANYNAME] = SELECTEDVALUE('CWMT_MS_QUOTINGREQUESTTRACKER - Master'[COMPANYNAME])

        && 'CWMT_MS_QUOTINGREQUESTTRACKER - Master'[TASKNAME] = "110 - Attach NPS Packets to Quotes"

        && 'CWMT_MS_QUOTINGREQUESTTRACKER - Master'[TASKSTATUS] = "Assigned"))

Var _b =

    CALCULATE(

        MAX('CWMT_MS_QUOTINGREQUESTTRACKER - Master'[TIME_STAMP]),

        FILTER(ALL('CWMT_MS_QUOTINGREQUESTTRACKER - Master'),

        [COMPANYNAME] = SELECTEDVALUE('CWMT_MS_QUOTINGREQUESTTRACKER - Master'[COMPANYNAME])

        && 'CWMT_MS_QUOTINGREQUESTTRACKER - Master'[TASKNAME] = "510 - Generate Customer Package"

        && 'CWMT_MS_QUOTINGREQUESTTRACKER - Master'[TASKSTATUS] = "Completed"))

Var _c =

    IF (_b > _a, _b)

RETURN

    DATEDIFF(_a, _c, DAY)

Test 3 = AVERAGEX('CWMT_MS_QUOTINGREQUESTTRACKER - Master', [Test 9])

Please advise! Thanks in advance.