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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
HubertZieciak
Frequent Visitor

Multiple Filters AND and OR

Hi All,

 

I need to filter my report by 2 different parameters but as "or" not "and" relation (so report should show data if one of those parameters is met).
When I use page level filters it works as "and" so all filter conditions must be met.
filters.PNG

 

I tried to make new column with IF function but paremeters I need to use are in different tables and it doesn't work.

 

Any ideas how to solve this issue?

1 ACCEPTED SOLUTION
AnthonyTilley
Solution Sage
Solution Sage

Are you able to use a lookupvalue in one of the tables to bring in the other value and then use an Or statment to say tru or false

 

filter =
Var col = LOOKUPVALUE(Table1[Column],Table1[ID],Table2[ID])
var ins = Table2[insurance Paid]

var check = if(or(col = "Withdrawn",ins = "UNPAID"),TRUE(),FALSE())

Return check




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
AnthonyTilley
Solution Sage
Solution Sage

Are you able to use a lookupvalue in one of the tables to bring in the other value and then use an Or statment to say tru or false

 

filter =
Var col = LOOKUPVALUE(Table1[Column],Table1[ID],Table2[ID])
var ins = Table2[insurance Paid]

var check = if(or(col = "Withdrawn",ins = "UNPAID"),TRUE(),FALSE())

Return check




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.