• I made a typo in there sorry, left off a square brack and forgot the keyword "Member".

    Yes it's always too early for MDX! Obviously by my error it was too late for MDX too 😉

    You're right you only need one "With" at the beggining and then you can list out the calcs

    Here's the right one:

    With Member [Measures].[Yesterday Clicks] as

    (

    [Measures].[Click Count]

    )