Forum Discussion

Chitemerere's avatar
Chitemerere
Responsive Resident
5 years ago
Solved

Remove Filters from DAX Measure

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

Need Help
  • Chitemerere's avatar
    Chitemerere
    5 years ago

    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

2 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    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's avatar
      Chitemerere
      Responsive Resident
      5 years ago

      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