Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: SSAS Calculated member with filter

    In that case you just change the specified member of UK to be the CurrentMember, but then you will have to slice your calculated measure byt he dimension to get...

  • RE: SSAS Calculated member with filter

    You already have 1 dimension filter so you should just have to add the next one the same way:

    CREATE MEMBER CURRENTCUBE.[Measures].PercentageCPM_Revenue

    AS IIF

    (

    [Measures].[Revenue No Over Del] = 0, NULL,

    ( [Campaign].[Metric].[Campaign Metric].&[CPM],...

Viewing 2 posts - 1 through 2 (of 2 total)