Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Sehlola
Regular Visitor

Remove filters from a measure

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:
Sehlola_0-1709629990434.png

 

 

1 ACCEPTED SOLUTION
PijushRoy
Super User
Super User

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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





View solution in original post

3 REPLIES 3
PijushRoy
Super User
Super User

Hi @Sehlola 

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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





PijushRoy
Super User
Super User

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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Unfortunately it still gives me the same result.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.