Forum Discussion

AK2025's avatar
AK2025
Regular Visitor
1 year ago
Solved

How to ignore Filter

Help....I'm trying ignore a slicer and have tried using Removefilters, and ALL, but the result is still affected by any selection from the slicer. Is there any suggestion what can be done? And, is t...
  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    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!

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
1 year ago

Hi,

Without seeing your sample pbix file, I am not sure how your semantic model looks like, but I guess your model includes sort_order column for the specific column.

I tried to create a sample pbix file like below, and please check the below picture and the attched pbix file.

 

 

 

 

expected result measure: = 
CALCULATE (
    SUM ( sales[sales] ),
    REMOVEFILTERS ( reason_slicer[reason], reason_slicer[reason_sort_order] )
)