• You could use a case statement or iif statement. I'd also use the non_empty_behavior clause as well

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

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

    ,NULL)

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

    Mack