Set alias in IIF statement

When you write IIF statement, whether as a part of the calculated member or select statement, often one tuple or set needs to be evaluated more than one time. For example, in the following query