Hi,

In the next query, I expected the same value for TotalSubCategory and Total1SubCategory calculated measures.

Why are these values distincts?

Thanks.

WITH

MEMBER [measures].[TotalSubCategory] AS ([Product].[subCategory].[All],[Measures].[Sales Amount])

MEMBER [measures].[Total1SubCategory] AS ([Product].[subCategory].[All],[Product].[Category].currentmember,[Measures].[Sales Amount])

SELECT

{

[Measures].[Sales Amount]

,[measures].[TotalSubCategory]

,[measures].[Total1SubCategory]

} ON 0

,NON EMPTY

(

[Product].[Category].children

,[Product].[subCategory].MEMBERS

) ON 1

FROM [Adventure Works];

**View Complete Post**

## MDX query using linked server - performance question