topic How to replace SUMMARIZE when it is depricated? in DAX Commands and Tips

How to replace SUMMARIZE when it is depricated?

Anonymous — Thu, 21 Jul 2022 07:13:56 GMT

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.

Re: How to replace SUMMARIZE when it is depricated?

SpartaBI — Thu, 21 Jul 2022 08:32:36 GMT

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

Re: How to replace SUMMARIZE when it is depricated?

PaulOlding — Thu, 21 Jul 2022 08:58:10 GMT

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> )

Re: How to replace SUMMARIZE when it is depricated?

Anonymous — Thu, 21 Jul 2022 08:59:43 GMT

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) )

Re: How to replace SUMMARIZE when it is depricated?

SpartaBI — Thu, 21 Jul 2022 08:59:42 GMT

Anonymous what PaulOlding said 🙂

Re: How to replace SUMMARIZE when it is depricated?

SpartaBI — Thu, 21 Jul 2022 09:02:16 GMT

Anonymous I wrote the code for your case:

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

Showcase Report – Contoso By SpartaBI