Forum Discussion

TaroGulati's avatar
TaroGulati
Helper III
3 years ago

Remove Interaction with page level filter

Hi everyone, 

 

I am not sure if it is feasible but wanted to know your suggestion. 

 

I have two simple tables: Table 1 and tabel 2

 

Table 2 is filtering table 1 with DIM key. As you can see last row of table 1 is not presnt is table 2. 

 

my objective is to put DIM field from table 2 on page level filter and filter as not blank. once i put this filter last row of table 1 is disappearing. Is there any way to avoid the page level filter only for this slicer?

 

Slicer on report coming from table 1 and filter on the right is coming fromt table 2.

 

I tried a measure like this :

Slicer Interaction = CALCULATE(DISTINCTCOUNTNOBLANK(Table1[Value]),REMOVEFILTERS(Table2)) 
 
but no success.
I have few restriction: 1) can not add additional row in table2 same as table 1.
2) I am restricted to use page level filter only on the right side not on the report. 
 
Thank you for tyour time and suggestions. 
 
 
Need Help

6 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Not if you use a page level filter.  It will work if you put it on a slicer instead and disable interactions between the two slicers.

     

    Generally that is a bad usage pattern.  What is your need to implement it like this?

  • TaroGulati's avatar
    TaroGulati
    Helper III
    3 years ago

    lbendlin Thank you so much for your comment. I am restricted to use the slicer in this way because in my report i have more then 55 pages and i want to insert the slicer on report level and it is easy to do it from right side pane. On few pages this slicer on the right can affect all the visual and slicers on the page on few it shouldn't, that's why i was trying to find a way to block the interaction. 

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      In general a page level or report level filter is much better than slicers everywhere.

       

      You could create a measure that overrides the filter if needed 

      • TaroGulati's avatar
        TaroGulati
        Helper III
        3 years ago

        lbendlin exactly, I am trying to use at page level here but I need to use also at report level. I tried the measure indicated in my post, do you have any suggestion how i can modify?

         

        thanks 

  • TaroGulati's avatar
    TaroGulati
    Helper III
    3 years ago

    lbendlin  disconnected table can't be implemented in my case. Only thing is if measure can impact the slcier but doesn't seems so. 

     

    Thanks for your suggestions