MDX 根据维度过滤的指标值出错

[c44323733]

每个 州的商店成本 mdx
WITH
SET [~ROWS] AS
{[Customer].[Customers].[State Province].Members}
SELECT
NON EMPTY {[Measures].[Store Cost]} ON COLUMNS,
NON EMPTY [~ROWS] ON ROWS
FROM [Sales]

结果如图


现在想定义一个指标，专门计算州为CA的 Store Cost指标

MDX
WITH
MEMBER [Measures].[B] AS
([Customer].[Customers].[State Province].[CA], [Measures].[Store Cost])
SET [~ROWS] AS
{[Customer].[Customers].[State Province].Members}
SELECT
NON EMPTY { [Measures].[Store Cost],[Measures].[B]} ON COLUMNS,
NON EMPTY [~ROWS] ON ROWS
FROM [Sales]

结果如图


为什么 [Measures].[B] 出现好多一样的值 ？？，我只想 [Measures].[B] 保留CA的值 ，其余的为空，怎么写，求教大神，，，，