Home Forums Data Warehousing Analysis Services Display measure value based on max value of another measure in SSAS cube RE: Display measure value based on max value of another measure in SSAS cube

  • From what I can tell, you would just take the max of your first measure over your dimension members and the max of your 2nd member over your dimension members and then do some sort of calculation on it?

    The following example takes the maximum reseller sales year total and the maximum internet orders year total and then multiplies them (in adventure works):

    WITH MEMBER [MaxReseller]

    AS

    MAX

    ([Date].[Fiscal].[Fiscal Year], [Measures].[Reseller Sales Amount])

    MEMBER [MaxInternet]

    AS

    MAX

    ([Date].[Fiscal].[Fiscal Year], [Measures].[Internet Order Count])

    MEMBER MaxCalc

    AS

    MaxInternet*MaxReseller

    SELECT

    {[Measures].[Reseller Sales Amount], [Measures].[Internet Order Count],

    MaxReseller, MaxInternet, MaxCalc } ON 0,

    [Date].[Fiscal].[Fiscal Year] ON 1

    FROM

    [Adventure Works]

    I hope that helps 🙂


    I'm on LinkedIn