Forum Discussion

HubertZieciak's avatar
HubertZieciak
Frequent Visitor
7 years ago
Solved

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...
Need Help
  • AnthonyTilley's avatar
    AnthonyTilley
    7 years ago

    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
AnthonyTilley's avatar
AnthonyTilley
Solution Sage
7 years ago

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