Forum Discussion

Sarutra's avatar
Sarutra
Icon for Helper I rankHelper I
1 year ago
Solved

Ignoring external date filter

Hello, I have the measure 'Unpaid Full Invoice Amount TREATAS', but I can't get it to return a result such that if I apply an external filter for January 2024, the visualization displays all values ...
Need Help
rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
1 year ago

Hi Sarutra

 

To ignore an external date slicer and always return values from a specific fixed range say from January 1, 2024 to January 31, 2025, regardless of any user-applied filters you'll need to build a measure that explicitly overrides the filter context.

You can write this DAX measure :

 

FixedDateTotal = 
CALCULATE (
    SUM ( 'Invoice'[Amount] ),
    REMOVEFILTERS ( 'Date'[Date] ),
    'Date'[Date] >= DATE (2024, 1, 1) &&
    'Date'[Date] <= DATE (2025, 1, 31)
)

You can try these steps:

 

  • REMOVEFILTERS('Date'[Date]) clears any external slicer or visual filter on the date field.

  • The date range condition inside CALCULATE then reapplies a fixed filter from 2024-01-01 to 2025-01-31.

  • This ensures the measure always returns values for your desired date window even if the report user filters to something else like 2023 or 2026.