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.

 

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.