SUMMARIZE function

[vijay273162]

Hi All,

I have a Dimension table with millions of records.

I try to perform the SUMMARIZE function on this DIMENSION table, and it gives me "memory exceeds error".

What's the solution for this. 

BEST PRACTICE TO USE SUMMARIZE FUNCTION ON LARGE DIMENSION TABLE ?

[vijay273162]

Here is the screenshot and DAX code written from my side.

SUMMARIZECOLUMNS(table[ID],table[Document Type])

The problem is, SUMMARIZECOLUMNS didn't work when i include table[ID], since the records are large

(111 million).

How to overcome this ?

[YukiK]

What does your code look like? We shouldn't add columns within SUMMARIZE() as a rule of thumb. You can look at best practices in this article: https://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/

Please give it a thumbs up if this is helpful!