Forum Discussion

MichaelDWebb's avatar
MichaelDWebb
Frequent Visitor
7 years ago
Solved

Dynamic Filter based on another Filter

I have a report that has a table that shows open purchase orders. Purchaing manager then has a set of filters that shows problematic line items. I would like to take the list of purchase order number...
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi MichaelDWebb 

     

     

    No worries. Just change the Check measure as follows

     

    Check =
    IF (ISFILTERED(POS[PO]) ,
        IF(VALUES(Data[PO]) in Values((POS[PO])), "Y","N"),"N"
    )
     
    This will work even if there are mutiple selection on POS[PO].
     
    I have added one more "N" to tell that if none is selected the entire Data Table will be displayed.
     
     
    Cheers
     
    CheenuSing
     
     
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi MichaelDWebb 

 

 

No worries. Just change the Check measure as follows

 

Check =
IF (ISFILTERED(POS[PO]) ,
    IF(VALUES(Data[PO]) in Values((POS[PO])), "Y","N"),"N"
)
 
This will work even if there are mutiple selection on POS[PO].
 
I have added one more "N" to tell that if none is selected the entire Data Table will be displayed.
 
 
Cheers
 
CheenuSing
 
 
MichaelDWebb's avatar
MichaelDWebb
Frequent Visitor
7 years ago

Hi Anonymous,

 

Thank you, this worked perfectly. Is there a way to auto check all of the items on the slicer?

 

Thansk,

Mike