topic Repeating DAX formula on different column but getting incorrect data in DAX Commands and Tips

Repeating DAX formula on different column but getting incorrect data

joshs444 — Sat, 04 Mar 2023 02:39:58 GMT

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