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 filter to be something like,

filter page, where

(Documents[StatusID] = 6) OR (Cases[CasesCompletionDate] IS NOT NULL).

This works in SQL, but I can't find a DAX equivalent.

 

I want the page to show documents where either or both of these criterea have been fulfilled. Can this be done?

 

If this needs further clarification then I am happy to provide it. This is a link to my data

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

 

Thanks in advance!

Need Help

4 Replies

  • 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!