Forum Discussion

rveerasamy's avatar
rveerasamy
Helper III
3 years ago

when applying filter should not affect dax measure

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
Power BI Dax

1 Reply

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    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 )