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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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