topic Re: ignore filter not working in DAX Commands and Tips

ignore filter not working

Bellringing — Fri, 09 Feb 2024 19:44:21 GMT

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

Dangar332 — Fri, 09 Feb 2024 20:13:39 GMT

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

Bellringing — Fri, 09 Feb 2024 20:20:31 GMT

Thanks. This feature work perfect for me