Use value of another field if blank

[Beho]

Hello,

I have a table of 3 columns (Status, Original Assignee Name, Current Assignee Name), and for the Assignee names, it's usually one of the other. I am trying to create a measure that checks if (Current Assignee Name) is blank, and returns (Original Assignee Name), else return (Current Assignee Name).

Every time I try to enter my measure formula, it only shows my other calculated fields and not the rest of the table. I was planning to use something like this:

_Final Assignee =
IF(
    ISBLANK('Progress records'[Current Assignee Name]),
    'Progress records'[Original Assignee Name],
    'Progress records'[Current Assignee Name]
)

[CoreyP]

Add that as a calculated column, not a measure.

[Beho]

I only have read-only access to the dataset, so cannot create columns. Is that the only way to approach this?

[CoreyP]

You could try adding SELECTEDVALUE() around each of your field references. 

[Beho]

Tried that as well, and got an error, as I cannot return a value if SELECTEDVALUE ="". Thanks.

[CoreyP · Accepted solution]