Remove filters from a measure

[Sehlola]

Hi All

I am trying to get a full year budget using a measure. I have tried REMOVEFILTERS and ALL functions and they don't seem to work. What I am tring to ignore is the date slicer:

Annual Budget = CALCULATE(SUM('2023'[Value]),FILTER('2023','2023'[Type] = "Budget"),ALL('2023'[Formatted Date]))

The screenshot below shows that the annual budget stills returns the selected month's budget. Any help will be appreciated:

[PijushRoy]

Hi @Sehlola 

Please share your Data Model
Which field you are using in Slicer 
If possible create and share link for sample PBIX file 

[PijushRoy · Accepted solution]

Hi @Sehlola 

Please try below DAX

Annual Budget = CALCULATE(SUM('2023'[Value]),REMOVEFITLER(Table[Month]),FILTER('2023','2023'[Type] = "Budget"))

Make sure you are using same filed in REMOVEFILTER which is using in Slicer

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[Sehlola]

Unfortunately it still gives me the same result.