Row Context and return a single value from Column

I'm struggling with evaluating a row context to determine if the specific row I'm in meets certain criteria. I get the error that basically indicates to me that I'm returning a table of values (I'm assuming as part of the VALUES function) rather than a scalar value, even though in my context, the Table Visual only has a single value that meets the criteria.

In simple terms, what I want is:

For given row, if value in column A = X then return a specific value.

I found this thread, but not fully wrapping my head around it: https://community.powerbi.com/t5/Desktop/Trying-to-return-a-single-value-if-one-row-from-another-table/m-p/909833#M436053

Here is my very simple measure:

Measure 2 = 
    IF(
        CONTAINSSTRING(
            VALUES(prog_SiteProgram[CSCat]),
            "TGH:Acute Care:Ambulatory"
        ),         
        [1.acu.a Value],
        BLANK()
    )

I'm happy with the filtering that is applied on the page, so I don't think I need a CALCULATE function, for the Table that I add the Measure too, I just need it to return in the proper context.

Hope this makes sense...

Thanks,

-Robert