DAX Query Not Enough Memory

[tecumseh]

Hi all,

Using PBID Oct, 2024.
16 GB Ram
64 bit Windows

Getting Memory errors in both DAX Query View and DAX Studio
Fact table is only 61K rows, dim tables are much less.|
Any ideas?

 /* START QUERY BUILDER */
EVALUATE
SUMMARIZECOLUMNS(
    dimAccounts[Account],
    dimAccounts[Account Description],
    GL_Data[Vendor ID],
    dimVendors[Vendor_Normal],
    GL_Data[Description],
    GL_Data[Amount],
    GL_Data[Year],
    KEEPFILTERS( FILTER( ALL( GL_Data[Vendor ID] ), NOT( ISBLANK( GL_Data[Vendor ID] ))))
)
ORDER BY 
    dimAccounts[Account] ASC,
    dimAccounts[Account Description] ASC,
    GL_Data[Vendor ID] ASC,
    dimVendors[Vendor_Normal] ASC,
    GL_Data[Description] ASC,
    GL_Data[Amount] ASC,
    GL_Data[Year] ASC
/* END QUERY BUILDER */

Thanks,

-w

[tecumseh]

Thanks @PijushRoy ,

That solved it - thanks!

[PijushRoy]

You are welcome

[PijushRoy · Accepted solution]

Hi @tecumseh 

Can you please check below code, please share status

EVALUATE
VAR FilteredGLData =
    FILTER(
        GL_Data,
        NOT(ISBLANK(GL_Data[Vendor ID]))
    )

RETURN
SUMMARIZECOLUMNS(
    dimAccounts[Account],
    dimAccounts[Account Description],
    GL_Data[Vendor ID],
    dimVendors[Vendor_Normal],
    GL_Data[Description],
    GL_Data[Amount],
    GL_Data[Year],
    KEEPFILTERS(FilteredGLData)
)
ORDER BY 
    dimAccounts[Account] ASC,
    dimAccounts[Account Description] ASC,
    GL_Data[Vendor ID] ASC,
    dimVendors[Vendor_Normal] ASC,
    GL_Data[Description] ASC,
    GL_Data[Amount] ASC,
    GL_Data[Year] ASC