• Many thanks.

    I think it is a good soluton too.

    Someone advice me that is it works the same...

    IIF(ISEMPTY([Measures].[Sales Amount] )

    ,NULL

    ,SUM ({ [Company].[All Company].[COMET]},[Measures].[Sales Amount]) )

    ,NON_EMPTY_BEHAVIOR = {[Measures].[Sales Amount]}

    Thanks a lot.

    Sorry but even if i use SSAS 2008 R2 from a long time (5 years) , i am not so good in MDX.

    i HAVE TO IMPROVE MY knowledge.