Repeating DAX formula on different column but getting incorrect data

[joshs444]

I wrote the below DAX measure:

X Days Received to Deliver Petco =

VAR xDays = SELECTEDVALUE( 'Days Table'[Days])

VAR Result =

 CALCULATE(

     [Order Count],

     'ORDER LOG'[Received To Delivered] = xDays,

     'ORDER LOG'[Customer] = "PETCO"

 )

 RETURN

 Result

it is pulling incorrect data:

The correct data should be 10 for column 7 in the table, but for some reason it is only counting 1.

I have the same DAX measure for a different column and it is calculating correctly:

X Days Received to Requested Deliver Petco =

VAR xDays = SELECTEDVALUE( 'Days Table'[Days])

VAR Result =

 CALCULATE(

     [Order Count],

     'ORDER LOG'[Requested Days To Deliver] = xDays,

     'ORDER LOG'[Customer] = "PETCO"

 )

 RETURN

 Result

Any idea why the data isnt pulling correctly into the table?

Thanks for the help