Forum Discussion

Sarah_Maes's avatar
Sarah_Maes
Frequent Visitor
2 years ago

Long Term Solution: Ignoring Page-Level Filters with ISFILTERED

Hi all, Thank you for reading my question. I’ve created a slicer panel that contains several slicers. Because this slicer panel can be expanded or minimized, when minimized I want to let user...
Need Help
FedeMosquera's avatar
FedeMosquera
Frequent Visitor
1 year ago

Hi, I know it's and old topic but I had the same issue and I solved it like this.

In my case I had one page level filter that excluded only one of the items in dimension A. What I did was count how many filters I had on screen (the _AllSelected Variable) vs how many there were in total (_Allfilters Variable). If that substraction is more than 1 (remember in my case only one item would be filtered out in the page level filters), then it means I have something filtered.

 

IF (
       (
         VAR _AllFilters = 
            CALCULATE(
                COUNTROWS(VALUES(DimensionA[Items])),
                ALL(DimensionA[Items])
                    )
         VAR _AllSelected = COUNTROWS(FILTERS(DimensionA[Items]))
         RETURN
         _AllFilters-_AllSelected
        ) 
    >1, 
    "Filters are applied",
    "No filters applied"
   )

 

Hope this helps.

 

Regards,

Federico