Forum Discussion

Nimai123's avatar
Nimai123
Post Patron
6 years ago

Memory error

We are trying to solve the issue. We got the problem by the following DAX query on the calculated column -   Final 2 = VAR a = CALCULATE( MAX('stg kronos'[ENDDTM]), FILTER( ALLEXCEPT('stg kro...
Need Help
Tahreem24's avatar
Tahreem24
Super User
6 years ago

Nimai123 ,

Try to increase the Maximum allowed to 16000 under File / Options and Settings / Options / Global / Data Load.  Data Cache Management Options.

 

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    Nimai123 ,

    I have opened your file at my side and havent got any such error.

    First thing, there is no issue with CALCULATE. If it's running fine with your one enviornment so how can you say that there is a issue with CALCULATE while running into production ???

    Second thing, there is no issue with DAX. Your issue is related with memeory/cache size. 

    I can successfully run your file and DAX at my side wihtout any error.  (see the below SS)

     

  • Nimai123's avatar
    Nimai123
    Post Patron
    6 years ago

    Thanks Tahreem24  for the response on the thread

     

    We have increased the cache size up to 54000 which is equivalent to 54 GB

     

    The file which you are using contains the sample data and the screenshot for the error from the production database which is causing the memory issue.

     

     

  • sarveshpandey23's avatar
    sarveshpandey23
    Frequent Visitor
    6 years ago

    Hi Tahreem24,

     

    We tried that as well by increasing the cache memory to 54000 Mb but still we are getting the same error.

     

    About the production thing, we are running the DAX query on the table with approx 12 lakhs rows. 

     

    Note - Created a VM with 64Gb Ram and throwing memory allocation error after increasing the cache memory size.