Filter by one column or another

[Anonymous]

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!

[mussaenda]

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]

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]

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

[v-danhe-msft]

Hi @Anonymous ,

Could you have tried with OR function for your report:

https://docs.microsoft.com/en-us/dax/or-function-dax

Regards,

Daniel He