How to replace SUMMARIZE when it is depricated?

[Anonymous]

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 · Accepted solution]

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]

@Anonymous what @PaulOlding said 🙂

[SpartaBI]

@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

[SpartaBI]

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

[Anonymous]

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