DAX to handle to possible options

[WhaleWatcher222]

Hi Experts

Is it possible to have two option in the following DAX 

See image below

Option 1	Option 2
Blank Cell	TBC

The below works when the cell is blank i want the and or option if the cell is not blank but TBC then return TBC as opposed tp "N/A"

5.2 Blanks = 
VAR Avalue = AVERAGE([5.2])
RETURN
    IF(ISBLANK(Avalue),"N/A",Avalue)

[danextian]

Hi @WhaleWatcher222 

You can try this:

5.2 Blanks =
VAR Avalue = AVERAGE ( [5.2] ) 
RETURN 
    COALESCE ( Avalue, [TBC measure] )

COALESCE returns the first non-blank value among the values inside it.

Note: The measure will return a text if TBC is also a text.