Difference Summarize and Summarizecolumns

[Anonymous]

Use TopN and want the Total in a tabel sum all the rows in the table by using SUMX.

To Sum I use SUMX together with SUMMARIZE. But prefer to use SUMMARIZECOLUMNS.

For both for a test, I have tried with SUMMARIZE and SUMMARIZECOLUMNS to created a New Table in PBI. The two tables are equal.

Then In a vizualization Table, when I add the SUMX with SUMMARIZE the Visualization still work. When try with SUMX with SUMMARIZECOLUMNS. Error "Couldn't load the data....

Am I doing somthing wrong. Have read about SUMMARIZE and SUMMARIZECOLUMNS. Can't see why it don't work.

Attach two picture. Meassures and the test model.

Thank you.

[Anonymous]

The book in Purple colour : The Definitive Guide to DAX By Marco and Albero. On page 256. In the Text box:

"You will not use SUMMARIZECOLUMNS in measures, becasue it cannot have outside filter context". 

I use SUMMARIZECOLUMNS in SUMX. Is that the reason ?   Maybe.

Until now haven't found a solution.

It works with SUMMARIZE.

Thank you for your contribution.

[HankCostner]

I had a similar issue and ended up using SUMMARIZE instead of SUMMARIZECOLUMNS to calculate Mean Average Percentage Error (MAPE) at a specific granularity.

https://stackoverflow.com/questions/59843180/incorrect-totals-in-power-bi-table-for-mape 

MAPEX = SUMX ( SUMMARIZE ( Forecast, 'Product'[ItemName], 'Calendar'[Year], 'Calendar'[Month] ), [Absolute Percentage Error] ) 

[amitchandak]

Refer

https://www.sqlbi.com/articles/introducing-summarizecolumns/

https://www.sqlbi.com/blog/marco/2017/02/02/using-summarizecolumns-instead-of-summarize-in-dax-power...

[Greg_Deckler]

See if this thread helps:

https://community.powerbi.com/t5/Desktop/SummarizeColumns-and-AddMissingItems-may-not-be-used-in-thi...