Generate text based on condition like in Excel

Hi bmk ,

I created a sample pbix file(see attachment), please check whether that is what you want.

Create a measure or calculated column as below to get the status text:

Measure = 
VAR _curvalue =
    SELECTEDVALUE ( 'Table'[A] )
RETURN
    IF (
        _curvalue > 10,
        "Cell is greater than 10",
        IF ( _curvalue < 10, "Cell is less than 10", "Cell is equal to 10" )
    )

Column = 
SWITCH (
    TRUE (),
    'Table'[A] > 10, "Cell is greater than 10",
    'Table'[A] < 10, "Cell is less than 10",
    "Cell is equal to 10"
)

Best Regards