Forum Discussion

Bellringing's avatar
Bellringing
Frequent Visitor
2 years ago
Solved

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)


But the DAX seem not working 

 

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
 


  • Dangar332's avatar
    Dangar332
    2 years ago

    hi, Bellringing 

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

    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 

     

2 Replies

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    hi, Bellringing 

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

    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