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
sahilhira162
Advocate I
Advocate I

MULTIPLE FILTERS WITH OR CONDITION

Hi

 

I am new to powerBI, I have a report with 2 different columns Start_date and End_date. Some of the projects don't have a Start_date and End_date. I am looking to create a simple report where either my start_date is blank OR my end_date is blank. When I put start_date is blank and add end_date is blank in filter pane, it acting as an AND feature. I want it to work it as an OR feature. 
Any help or workaround is appreciated.

Thanks

1 ACCEPTED SOLUTION
v-jiascu-msft
Employee
Employee

Hi @sahilhira162,

 

There is a workaround. 

If these two columns are in one table, we could use this formula in a calculated column as a tag.

Flag =
IF ( ISBLANK ( [column1] ) || ISBLANK ( [column2] ), 1, 0 )

If these two columns aren't in one table, we could use this formula as a measure. The two tables should have a 1:1 relationship.

MeasureFlag =
IF (
    ISBLANK ( MIN ( 'Table1'[column1] ) ) || ISBLANK ( MIN ( 'Table2'[column1] ) ),
    1,
    0
)

 

MULTIPLE FILTERS WITH OR CONDITION.JPG

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

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

View solution in original post

2 REPLIES 2
v-jiascu-msft
Employee
Employee

Hi @sahilhira162,

 

Could you please mark the proper answer if it's convenient for you? That will be a help to others.

 

Best Regards!
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-jiascu-msft
Employee
Employee

Hi @sahilhira162,

 

There is a workaround. 

If these two columns are in one table, we could use this formula in a calculated column as a tag.

Flag =
IF ( ISBLANK ( [column1] ) || ISBLANK ( [column2] ), 1, 0 )

If these two columns aren't in one table, we could use this formula as a measure. The two tables should have a 1:1 relationship.

MeasureFlag =
IF (
    ISBLANK ( MIN ( 'Table1'[column1] ) ) || ISBLANK ( MIN ( 'Table2'[column1] ) ),
    1,
    0
)

 

MULTIPLE FILTERS WITH OR CONDITION.JPG

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

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

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

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.