Forum Discussion

6 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    5 years ago

    try:

    Sum Pay1 = CALCULATE (SUM(Table[Pay1]), ALLEXCEPT(Table, Table[SignedDate]))

     

    etc...

    • Brite's avatar
      Brite
      Helper I
      5 years ago

      PaulDBrown Forgot to mention Pay1, Pay2, Pay3... are all measures. The Dax formula above doesn't accept sum('Tablename'[Pay1]). How would I sum Dax measures (Pay1, Pay2, Pay3..)? 

      • PaulDBrown's avatar
        PaulDBrown
        Community Champion
        5 years ago

        It depends on what the measures calculate, but in  principle:

        Sum Pay1 by month= CALCULATE [Pay1],  ALLEXCEPT(Table, Table[SignedDate]))

         

        or

        SUMX(ALLEXCEPT(Table, Table[SignedDate]), [Pay1]))