| title | = (Equal To) (MDX) | Microsoft Docs |
|---|---|
| ms.date | 06/04/2018 |
| ms.prod | sql |
| ms.technology | analysis-services |
| ms.custom | mdx |
| ms.topic | reference |
| ms.author | owend |
| ms.reviewer | owend |
| author | minewiskan |
Performs a comparison operation that determines whether the value of one Multidimensional Expressions (MDX) expression is equal to the value of another MDX expression.
Note
To compare objects, use the IS (MDX) operator. For example, use the IS operator when you are checking if the current member on a query axis is a specific member.
MDX_Expression = MDX_Expression
MDX_Expression
A valid MDX expression.
A Boolean value based on the following conditions:
-
true if the value of the first parameter is equal to the value of the second parameter.
-
false if the value of the first parameter is not equal to the value of the second parameter.
-
true if both parameters are null, or one parameter is null and the other parameter is 0.
The following query shows examples of these conditions:
With
--Returns true
Member [Measures].bool1 as 1=1
--Returns false
Member [Measures].bool2 as 1=0
--Returns true
Member [Measures].bool3 as null=null
--Returns true
Member [Measures].bool4 as 0=null
--Returns false
Member [Measures].bool5 as 1=null
Select {[Measures].bool1,[Measures].bool2,[Measures].bool3,[Measures].bool4,[Measures].bool5}
On 0
From [Adventure Works]