when applying filter should not affect dax measure

[rveerasamy]

Hi Experts,

I'm searching for solution that when applying filter it should not affect dax.

Days To Fulfill =

VAR childorderdate =CALCULATE(

    MAXX(CALCULATETABLE('PBI_BBA_SALES',FILTER('PBI_BBA_SALES',NOT ISBLANK('PBI_BBA_SALES'[Ref Id]) ) ),PBI_BBA_SALES[Order Date])

)

Return DATEDIFF(MAX('PBI_BBA_SALES'[Order Date]),childorderdate,DAY)

this is the measure I have created but when I add filter to the table it should not affect the dax
this is the solution I need

@timl 

[tamerj1]

Hi @rveerasamy 

please clarify what do you mean by "when I add filter to the table it should not affect the dax"

Also both CALCULATE and CALCULATETABLE are doing nothing in this case. Can simply write 

Days To Fulfill =
VAR childorderdate =
MAXX (
FILTER ( 'PBI_BBA_SALES', NOT ISBLANK ( 'PBI_BBA_SALES'[Ref Id] ) ),
PBI_BBA_SALES[Order Date]
)
RETURN
DATEDIFF ( MAX ( 'PBI_BBA_SALES'[Order Date] ), childorderdate, DAY )