cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Responsive Resident

## 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

1 ACCEPTED SOLUTION
Responsive Resident

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 2
Microsoft Employee

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

@mahoneypa HoosierBI on YouTube

Responsive Resident

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors