with
member [cc] as //本年累计。“本年中标,并且在统计区间已经签约”的客户数
exists(
filter(CROSSJOIN([DimCustomer].[Customer].ALLMEMBERS,
[DimProjPhse].[Project Phase Level 2].&[2], --已签约
ancestor([DimTime].[Year - Week - Date].currentmember,[DimTime].[Year - Week - Date].[Year]).FIRSTCHILD
:[DimTime].[Year - Week - Date].currentmember),
[Measures].[Far Bid Invst Customer Qty] = 1
),
filter(CROSSJOIN([DimCustomer].[Customer].ALLMEMBERS,
[DimProjPhse].[Project Phase Level 2].&[1], --已中标
ancestor([DimTime].[Year - Week - Date].currentmember,[DimTime].[Year - Week - Date].[Year]).FIRSTCHILD
:[DimTime].[Year - Week - Date].currentmember),
[Measures].[Far Bid Invst Customer Qty] = 1
)
).count
这个MDX出不了正确结果,哪位指点一下,该怎么写