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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors