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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Bellringing
Frequent Visitor

ignore filter not working

Hi Buddy, 

 

I am trying to figure out how ignore content filter work on Power BI. A chart that ignore the content filter. 

It looks like the DAX ignore is just on the measure, the dimension is still affect the content filter. 

Left hand side is a filter, when I select the data, my expectation on the right should be change at all. (ignore the filter on openDate)

Bellringing_0-1707507220285.png
But the DAX seem not working 
Bellringing_1-1707507381046.png

 

Here is my DAX

ticketCount =
    calculate( COUNT(Sheet1[id]),
        REMOVEFILTERS(Sheet1[openDate])
    )
I tried both All(Sheet1[openDate]) ,  All(Sheet1) . All not working for me 

 

Here is my dataset

idopenDatecloseDateStatus
12/1/2024 Open
22/2/2024 Open
32/3/2024 Open
42/1/2024 Open
52/2/2024 Open
62/1/20242/2/2024Close
72/2/20242/3/2024Close
 


1 ACCEPTED SOLUTION
Dangar332
Super User
Super User

hi, @Bellringing 

you nedd to use edit interaction for slicer not affect your particular visuals

Dangar332_1-1707509420393.png

1. select your slicer or visual where you want to edit interaction

2. go to format pane and select edit-interaction

3. select none for stop interaction 

 

LINK  for edit interaction 

 

View solution in original post

2 REPLIES 2
Dangar332
Super User
Super User

hi, @Bellringing 

you nedd to use edit interaction for slicer not affect your particular visuals

Dangar332_1-1707509420393.png

1. select your slicer or visual where you want to edit interaction

2. go to format pane and select edit-interaction

3. select none for stop interaction 

 

LINK  for edit interaction 

 

Thanks. This feature work perfect for me

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.