strange behaviour SUMMARIZECOLUMNS

[Anonymous]

good day

why this measure is working

EVALUATE

    CALCULATETABLE (
        SUMMARIZE (
           Balance_Facts_Final_View,
            VTime[PK_Date],
            GEO[id],
            Balance_Facts_Final_View[ClientID],
            "Measure_ID", 10001,
            "Measure", "КБ Факт РасчСчета",
            "SummaNP", ROUND ( DIVIDE ( SUM ( Balance_Facts_Final_View[Summa_np_round] ), 1000 ), 0 )
        ),
        F101_dimension[2nd_level] = "расчетные счета",
        VTime[PK_Date] = DATE ( 2020, 4, 1 ),
        Balance_Facts_Final_View[Category_Summa] = "Остаток"
    )

but this measure is not working

EVALUATE
        SUMMARIZECOLUMNS (
            VTime[PK_Date],
            GEO[id],
            Clients_Dim_PP[ClientID],
            F101_dimension[2nd_level],
            Balance_Facts_Final_View[Category_Summa],
            filter (F101_dimension, F101_dimension[2nd_level] = "расчетные счета"),
            filter (Balance_Facts_Final_View, Balance_Facts_Final_View[Category_Summa] = "Остаток"),
            filter ( VTime, VTime[PK_Date] = DATE ( 2020, 4, 1 ) ),
             "Measure_ID", 10001,
            "Measure", "КБ Факт РасчСчета",
            "SummaNP",  ROUND ( DIVIDE ( SUM ( Balance_Facts_Final_View[Summa_np_round] ), 1000 ), 0 )
)

[amitchandak]

@Anonymous , what is the issue.

[Anonymous]

1-st measure with summarize works very quickly and 2-nd with summarizecolumns is never ending

[TomMartens · Accepted solution]

Hey @Anonymous ,

one of the reasons could be that SUMMARIZE implicitly creates a context transition, SUMMARIZECOLUMNS does not.

Without more knowledge about your data model, it's very difficult to provide more information. Please refer to these articles by the guys from sqlbi:

• https://www.sqlbi.com/articles/introducing-summarizecolumns/
• https://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/

Hopefully this helps to tackle your challenge.

Regards,

Tom