ssas - MDX 不等于基本问题

Question

我是 SSAS 和 SSRS 的 BI 初学者，我有一个关于 MDX 的非常基本的问题。

获取计算成员中与条件匹配的所有值非常容易。例如

WITH MEMBER [MEASURES].TOTAL_DOT_TEST
 AS
(
[Dim Transportation Incident Dot Classification].[Dim Transportation Incident Dot     Classification].&[3],
[Measures].[Fact Transportation Incident Count] 
)

将获取分类值为 3 的交通事故数量。

但是，使用此示例，我如何获取 ID 不为 3 的交通事件的数量？

有点像选择 *从表其中分类 <> 3

谢谢

Answer 1

您可以使用 Aggregate () 和 Except () 如下:

WITH MEMBER [MEASURES].TOTAL_DOT_TEST
 AS Aggregate (   
      Except( 
        [Dim Transportation Incident Dot Classification].[Dim Transportation Incident Dot     Classification].members ,
        { [Dim Transportation Incident Dot Classification].[Dim Transportation Incident Dot     Classification].&[3] }
      ),
      [Measures].[Fact Transportation Incident Count] 
)