Conditional Color based on COUNT for Guage Visual and multiple tables

I'm trying to show a visual of authorized position for multiple locations vs actual. 

RESULTS: RED gradient for 'under manned' and GREEN gradient for 'overmanned' and WHITE if authorized equals manned.

Table1: all manning data every name, their job, location, etc (a living document)

Columns: [NAME], [LOCATION], [JOBTITLE], etc

Table2: a set document (that a director might change later based on needs) showing location, jobtitle authorized and paygrade this table includes every one of the 20 job authorizations at each of the locations.  So, I might have a total entry of 16 jobcode 3X3A across all locations, but 5 here and 3 there, etc. 

Columns: [LOCATION], [JOBTITLE], [PAYGRADE]

Current page setup is a slicer to filter by location and 20 GUAGE visuals (newCard would also work if easier) that are each filtered by a COUNT of each of the twenty Table1 and Table2[JOBTITLE] jobs... 3X3A, 3X3B, etc. This gives me two numbers to play with... Authorized and Assigned.

I think the tables are linked right as I get the correct results, but...

I'd love to have the visual show RED gradient if Assigned is less than Authorized, WHITE if equal, and GREEN gradient if overmanned.

I've dabbled in DAX, but don't know enough to figure this out from slightly related examples.  I've tried creating a new column that would do the count AND show me the difference between authorized and assigned... I'm just kinda stuck looking at a nice page I've created that is just all one color BLUE.

Any thoughts?? 

thx, -mm