Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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!

4 REPLIES 4
mussaenda
Super User
Super User

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
Not applicable

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!

 

 

Hi @Anonymous,

 

Bear with me, I am not a BI expert.

 

Untitled.png

 

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

The pbix link is here

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.