• Well the second one I didn’t understand, but then we can blame the coffee since apparently didn’t kick in yet 😀

    I must say I did try, but it didn’t go, I also tried

    member [Measures].[Click] As [Measures].[Click Count]

    since I do have a with at the beginning of the query. And still didn’t work lol. And of course I also tried changing the name from max to something else and nada de nada :w00t:

    member [Measures].[max] As

    max({[Hour Dim].[D Hour].[All].children},[Measures].[Purchase - converted to USD])

    maybe is just too early for mdx for me 😀