How to ignore Filter

Hello AK2025 

Thank you for reaching out to the Microsoft Fabric Community Forum

To ignore a slicer but still respect a page-level filter on the same column, you need to isolate the slicer's effect without clearing the entire column context, which ALL('Table'[Service]) and REMOVEFILTERS('Table'[Service]) do they remove all filters, including those from page-level filters.

To solve this, instead of removing all filters, you can selectively preserve the page-level filter context using KEEPFILTERS or by capturing the filter context outside the slicer via a virtual table.

 Consider the below DAX:

 

DEBUG Trial =

CALCULATE(

    DISTINCTCOUNT('Table'[Transaction]),

    FILTER(

        ALL('Table'),

        'Table'[Service] IN VALUES('Table'[Service])

    )

)

Additionally, If needed, you can consider creating a disconnected slicer table for Service, use that for selection, and write DAX that only uses it conditionally.

If this doesn’t fully meet your needs, could you kindly share a sample of your data and more detailed context? That would help us provide a more accurate solution.
 

If this response resolves your query, kindly mark it as Accepted Solution to help other community members. A Kudos is also appreciated if you found the response helpful.
 

Thank You!