Filtering Data based on most recent data labels

Update: 

I managed to solve Part 1 above but altering the DAX formula used for my colour coding. 

Originally my colour coding was:

Current Colour = IF('Table1'[Measure] >=90,1,

IF('Table1'[Measure] <90 && 'Table1'[Measure] >0,2,

IF('Table1'[Measure] <= 0, 3)))

And the same formula for the 'Previous Colour'

I simply added another part to the If statement as shown below:

Current Colour = IF('Table1'[Measure] >=90,1 && 'Table1'[Measure2] >0,

IF('Table1'[Measure] <90 && 'Table1'[Measure] >0 && 'Table1'[Measure2]>0,2,

IF('Table1'[Measure] <= 0 && 'Table1'[Measure2] >0, 3,

IF('Table1'[Measure2] =0,4))))

And then added a new rule for 4 to turn the cells white. Measure 2 is a sum of two calculated columns that search to see whether the person/task/team were in the previous or current month.

Still stuck on Part 2, if there is anything that can be done. 

Kind regards,

E