IIF

Description:

It is used to evaluate different branch expressions depending on whether a Boolean condition is true or false.

Syntax:

IIf(Logical_Expression, Expression1, Expression2)

Return Type:

SCALAR

Parameters:

Parameter	Description

Parameter	Description
Logical_Expression	It is a condition that evaluates to true (1) or false (0). It must be a valid MDX logical expression.
Expression1	It is used when the logical expression evaluates to true. Expression1 must be a valid MDX expression.
Expression2	It is used when the logical expression evaluates to true. Expression2 must be a valid MDX expression.

Example:

With Member [Measures].[Internet Gross Profit] as  
  IIF( [Measures].[Internet Order Quanlity]>10000,[Measures].[Internet Order Quanlity],1)  
SELECT NON EMPTY  
    [Measures].[Internet Gross Profit] ON 0,  
    [Product].[Product Categories].[Category] ON 1  
FROM [AdventureWorksMF]