topic Re: when applying filter should not affect dax measure in DAX Commands and Tips

when applying filter should not affect dax measure

rveerasamy — Thu, 06 Apr 2023 13:21:33 GMT

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

Re: when applying filter should not affect dax measure

tamerj1 — Thu, 06 Apr 2023 13:00:14 GMT

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 )