Search measures in a row and return Yes if any column in that row has a certain value

[skyfranks]

I have created several measures to compare two reports and return "Matched" or "Unmatched"  (my columns) for employee records to quickly identify which records may have a first name, title, etc. that doesn't match the other report.

This allowed me to create a table with all the values. I now want to create a formula/column that says "Yes" if any column in that row says "Unmatched", so I filter out rows where every data point matches and I can focus only on those that have an issue.

[skyfranks]

You were right. Thank you so much! A column worked.

[Syk]

Easiest way I can think to do this would be to go back and replace Matched and Unmatched with 0 and 1. Then just sum all the columns and if anything is >0, you know it doesn't match.

[skyfranks]

I just tried but my measures are IF statements (if match 0, if not 1) so it's not working to use SUM or Calculate. Any other thoughts?

Example:

Match Dept Code = IF(RELATED('GDS Headcount Prior Month'[Department Code])='GDS Resource Master'[Department Code],0,1)

[Syk]

You're using calculated columns for your matches. It still returns a 0 or 1, you just need to add them. So create another calculated column with all your matches specified (just use +)

Column 3 = 'Table'[Column]+'Table'[Column2]

[skyfranks]

They aren't popping up as a choice for me and error out when I manually type them in.  They aren't columns I created in the data set, they're measures I created. I might have to retool it to be actual columns?

[Syk]

You shouldn't need to mess with the actual columns (although that may be easier and less resource intensive!)
What you sent shows that they're calculated columns built using DAX. You should have no problem creating another calculated column to add them together?

If you're trying to create the sum column as a measure, you'll need to do it a bit differently but a column should be fine.

[skyfranks]

I need to sum across the rows, not down the columns. 

The goal is to know if any one of the many columns has a match problem, and then only show those rows instead of the thousands that may all match on every column.

[Syk]

That is the solution I'm giving you. In my screenshot, column3 sums across the rows. You can use column3 to filter the rest of your data.

I put together another example..
Currently, your data looks like this based on what you've posted after reworking it to be 0 and 1

What we will do now is create a column to sum all of these columns. In this randomly generated data, only 1 row would be correct (highlighted) 

In turn, I'd filter it out to only see the ones I want to focus on

[skyfranks]

I'm totally with you on the solution, but I cannot figure out why PBI will not let me select the measures I created. The ones that pop up are not the ones I need and when I manually type in the ones I need, it won't work.  Using Sum only lets me select one and not several measures.

[Syk · Accepted solution]

I think you're trying to create a new measure. Instead of a new measure, hit new column.