Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Filter by one column or another

Hi,   I am trying to add a page level filter to my report which is supposed to filter the page by one of two (or both) columns, Documents[StatusID] and Cases[CaseCompletionDate].    I want the fi...
Need Help
mussaenda's avatar
mussaenda
Community Champion
7 years ago
Filter = IF(Documents[StatusID] = "6" || Cases[CasesCompletionDate] <> BLANK(), 1, 0)

Asuming that [StatusID] is in text format. then drag the column to page filter and check 1 only

Anonymous's avatar
Anonymous
Not applicable
7 years ago

https://drive.google.com/open?id=1rHWNCVShe0KFpQddWJwajtbeBFNoT9-X

 

Hi mussaenda,


I have attached a link to a cut down version of my report. Currently, the 2 page level filters (Case Completion Date = is not blank & Posting Status ID = 6) are the 2 filters I want to be included in an OR filter.

 

I have made a calculated column, Documents[CompletedOrPostedFilterCol], which ideally would show 1 when either Case Completion Date = is not blank or when Posting Status ID = 6, but currently it shows 1 for every single value and I know that shouldn't be the case.

 

Thanks for your reply!

 

 

  • mussaenda's avatar
    mussaenda
    Community Champion
    7 years ago

    Hi Anonymous,

     

    Bear with me, I am not a BI expert.

     

     

    This is the output after filtering to ID=6 || Completion Date <> null.

    The pbix link is here