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-resp...
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
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