Clustered Bar Chart - How to visualize both static data and calculated data together?

Hi sharkrocket 

You could simply have a Disconnected table and handle with the DAX measure

Your Disconnected table could look like this:

Have a measure like this:

UnifiedMetricValue =
SWITCH(
    TRUE(),
    SELECTEDVALUE(Category[Metric]) = "Denominator" && SELECTEDVALUE(Category[Year]) = "Last Year", 12345,  -- static value
    SELECTEDVALUE(Category[Metric]) = "% Met Progress" && SELECTEDVALUE(Category[Year]) = "Last Year", 0.76, -- static value
    SELECTEDVALUE(Category[Metric]) = "% Complete" && SELECTEDVALUE(Category[Year]) = "Last Year", 0.45,     -- static value

    SELECTEDVALUE(Category[Metric]) = "Denominator" && SELECTEDVALUE(Category[Year]) = "This Year", [Denominator Measure],
    SELECTEDVALUE(Category[Metric]) = "% Met Progress" && SELECTEDVALUE(Category[Year]) = "This Year", [% Met Progress Measure],
    SELECTEDVALUE(Category[Metric]) = "% Complete" && SELECTEDVALUE(Category[Year]) = "This Year", [% Complete Measure]
)

 
In place of static value you could also refer to the column or table where this is instead or even use lookup if the metric is present in both the table depending on how your table looks

Example using Lookup:

UnifiedMetricValue =
VAR Metric = SELECTEDVALUE(Category[Metric])
VAR Year = SELECTEDVALUE(Category[Year])
RETURN
SWITCH(
    TRUE(),
    Year = "Last Year", 
        LOOKUPVALUE(LastYearMetrics[Value], LastYearMetrics[Metric], Metric),

    Year = "This Year" && Metric = "Denominator", [CY_Denominator],
    Year = "This Year" && Metric = "% Met Progress", [CY_MetProgress],
    Year = "This Year" && Metric = "% Complete", [CY_Complete]
)