Row Context and return a single value from Column

[Anonymous]

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-tab...

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

[Greg_Deckler · Accepted solution]

Measure = IF(MAX('Table'[Column]) = X,[1.acu.a Value],BLANK())

Assumes 1.acu.a is a measure.

[Anonymous]

Thanks @Greg_Deckler 

That works, why? I never would think to use MAX on an evaluation of a String.

[Greg_Deckler]

Think of using MAX and MIN on a string like "last" and "first".