Remove Filters from DAX Measure

[Chitemerere]

I have the following DAX measure:

The above measure is being inserted into a tool tip to give a constant value for the average daily sales between stated date periods and should be non-responsive to a date filter.  How can one make the above measure constant./removefilters so that it is not responsive to changes in dates?

Best regards,

Chris

[mahoneypat]

You could replace [First Date] and [Last Date] with hard-coded dates like DATE(2020,1,1).  Or you could replace with

CALCULATE([First Date], ALL('Date'))

Regards,

Pat

[Chitemerere · Accepted solution]

Many thanks, i had to put the ALL filter in the calculation of the First Date and Last Date as follows:

First Date = Calculate(min(FactDate[Date]), ALL(FactDate[Date]))

Best regards,

Chris