Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to replace SUMMARIZE when it is depricated?

I understand that the DAX function SUMMARIZE is deprecated and will eventually be removed. 

What alternative function can be used instead?

SUMMARIZECOLUMNS seems like the obvious one, but unfortunately it does not work within context transitions, so is not very useful.

  • PaulOlding's avatar
    PaulOlding
    4 years ago

    Hi Anonymous 

    Are you referring to this from dax.guide?

    It's not the whole SUMMARIZE function that's deprecated, just the ability to add new columns to the grouped table.

    The recommended way to do that would be

    ADDCOLUMNS(
    SUMMARIZE(Table, Table[Column]),
    "New Column Name", <Expression>
    )

     

5 Replies

  • PaulOlding's avatar
    PaulOlding
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi Anonymous 

    Are you referring to this from dax.guide?

    It's not the whole SUMMARIZE function that's deprecated, just the ability to add new columns to the grouped table.

    The recommended way to do that would be

    ADDCOLUMNS(
    SUMMARIZE(Table, Table[Column]),
    "New Column Name", <Expression>
    )

     

  • SpartaBI's avatar
    SpartaBI
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Anonymous who said SUMMARIZE is deprecated? 
    Do you have a reference for this announcement? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      SpartaBI , the relevant references are:

      Solved: DAX: Who wants a challenge with SUMMARIZE? - Microsoft Power BI Community

      SUMMARIZE – DAX Guide

       

       

      But it appears that only part of the SUMMARIZE functionality is being depricated: the parameters to create columns and expressions.

       

      So in my case, I would need to replace this existing DAX measure:

       

      Count Over 75 =
    SUMX(
        SUMMARIZE(
            'FactTable',
            'Employee'[EmpID],
            'Employee'[StoreID],
            'Project'[Project],
            "_Over75", IF([MeasureOfInterest] >= 75, 1)
        ),
        [_Over75]
    )

       

      with this syntax:

       

      Count Over 75 =
    SUMX(
        SUMMARIZE(
            'FactTable',
            'Employee'[EmpID],
            'Employee'[StoreID],
            'Project'[Project]
        ),
        IF([MeasureOfInterest] >= 75, 1)
    )