Home Forums Data Warehousing Analysis Services Aggregation of an MDX calculated measure when multiple time periods are selected RE: Aggregation of an MDX calculated measure when multiple time periods are selected

  • A suggestion from another source has solved this for me. I can use --

    iif(iserror([Date Dimension].[Fiscal Year Hierarchy].CurrentMember),

    , null

    , [Measures].[Acquisitions] - [Measures].[Growth in Commitments]))

    CurrentMember will return an error when multiple members have been selected.