Filter/Slicer When Either of Two Logical Fields is True

[Xaraja]

I am building a report that has a table with many rows and five columns. Two of the columns are a boolean true/false, and the vast majority of the rows will be false on both. The main use of the report will be to review rows where there's a mismatch - one false and the other true. Is there a way to filter/add a slicer that would show all the records where at least one of the boolean values is true? 

I do have two slicers, one for each of the boolean values, but then the user has to toggle them back and forth to see what they are looking for. I don't want to filter out all the rows that are false in both values because there are some that should be true and this report is intended for the user(s) to be able to see whether the product is set up correctly. 

[vojtechsima]

Hi, @Xaraja,
if I got your description right -> check whether one of the columns isTRUE:

IF('Table'[FirstCheck]=TRUE() || 'Table'[SecondCheck] = TRUE(), "Product with True", "Correct Product")

[Xaraja]

Goodness, I was making it way too hard! Thanks that will help a lot.

[jdbuchanan71 · Accepted solution]

@Xaraja 

The easiest option is probably to add a calculated column that compares the values in the two columns.

Fields Match = Table[Field1] = Table[Field2]

Then you can filer on that to = FALSE to find all those that don't match.