Inactive relationships in visuals

Not sure if this is possible, but wanted to through it out there:

I have a table table that shows a "snapshot" of data at various intervals (in this case, quarters).  In other words, every quarter when I load the data, I load in all of the detail records, with an "analysis date" serving as the "key" ( and the join to the date table).

I can then add calculated columns to populate the "previous quarter" value of certain fields (status, stage, etc). One of these fields is "score", which calculates out to A, B, C or D based on numerical values.  A,B,C,D each map to a color (green, beige, yellow, red), stored in a dimension table.  There is an active relationship between "score" and "color" and an inactive relationship between "prev q score" and color (in the model diagram below "MC" is A,B,C,D).  To calculate a measure using the "prev q" score, I can use USERELATIONSHIP, so no problem there.

The problem I have is trying to do a visualization using both the current color and previous color as a dimension (trying to show summarized changes per color and stage quarter over quarter, so for instance "Green"/"In Progress" would be -1).  I can write individual measures (with USERELATIONSHIP for previous q) for each quarter's (current and previous) color/stage combo, but that seems like a lot of "hard coding" and not conducive for showing multiple measures in one table (and I'm unsure how those would interact with other slicers).

Am I overthinking this, missing something fundamental or trying to do the impossible?

Thanks,

David

Model:

Visuals: