Update a Flag Based on Columns in Two Tables

Hello,

I am trying to recreate an Access database process in BI Desktop involving 3 separate relationships between two tables (3 Access queries) and resulting in an updated exclusion flag in one of the tables.

This is the table with the Exclusion criteria (tbl_00_Info_Excl_Rules):

This is the table where the "Exclude" flag will be updated (tbl_30_Analysis), with the expected result in the "Exclude" column, and a column that I added at the end to show which scenario (shown further below) resulted in the exclusion:

This is "scenario 1", where both columns must match to update the flag to a "Y":

This is "scenario 2", where Products match and Carrier "is null":

This is "scenario 3", where Carriers match and Product "is null":

I am very new to the BI platform (learning via self-paced tutorials) and have searched for clues in this and other forums for over a week.   have learned a lot but I am still at a loss.  I created a calculated field in both tables in BI that was a concatenation of the Carrier and Product, then created a relationship between the two tables.  This worked fine for exclusions where both Carrier and Product matched, but created inaccurate results for the other two scenarios.  By the way, I did create 3 separate flags in BI so that I could keep track of my results.

In my limited understanding, I attempted to use the RELATED function, the USERELATIONSHIP function, and even attempted creating a bridge.  All of this was a bit beyond my limited learning and I have been spinning my wheels for some days now.  My problem, as I best understand it, is that once I create a relationship with the concatenated columns, it throws off any comparisons I wish to later make between single columns, and vice versa. 

Any help that you can provide will be greatly appreciated.  We are in the process of adopting the BI platform and will eventually have many Access databases that we wish to "convert" to BI.

Thanks in advance!

~Julie