Showing results for 
Search instead for 
Did you mean: 
New Member

Ignoring filter in measure being impacted by date slicer

Hello community,


I have a pretty simple table:



I've added a measure called Total Hours

Total Hours = calculate(sum(Sheet1[Hours]),all(Sheet1[Type]))


And I'm trying to construct a pretty simple view:


If I press "Type 1" in the chart to filter by it, Person 1 hours correctly filters to 0.50 and Total Hours stays at 25.50 as intended (I want it to ignore the Type selection).


But if I engage the date slicer by changing the end to 4/24, the behavior above no longer stays the same. Person 1 has Hours = 22 and Total Hours = 22. When I click Type 1, Hours = 0.50 and Total Hours = 5.75. The 5.75 seems to be adding together all the Hours for 4/19 date for some reason.


I am hoping the Total Hours will still be unchanged in this scenario by staying at 22 (honoring the date slicer but ignoring the Type filter). What am I doing wrong to achieve that?


Thank you for any advice!




Hi @ga187 ,

Based on my test, I am afraid you could not achieve your result, the visual filter will fill the whole data for your report, if you do not want to ignore the filter, you could use the edit interaction function:



Daniel He


Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
New Member

Do I need to pull out total hours into it's own table to fix the issue? Was hoping to avoid doing that.

Helpful resources

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors