Forum Discussion
Calculate with filter causing not enough memory error
If you don't want to take the time to build some repreentative samples of your data tables, You should be able to share a picture of your data model (with relationships), column headers from your Tables, and Measure definitions. There should be nothing confidential there.
I at lest woudl have to see your data table layout. In geneal TALL is not a big deal but WIDE is very resource intensive. I would look at using lookup tables. Say you table contains Customer Number, Customer Name, Customer Adress, Phone, etc.. Product Name, Product Number, etc... this could all be stored in a lookup tables that is wider but short unless you have millions of customers.
I'm sure we can help with DAX but really need more information to help you. One very important piece is this Calulcated column in Query1 table?
I'm not sure how to post a sample PBIX file, so here are some more details and images
There are 2 tables; Query1 and Date. My Query1 table contains all of my login/logout times. My Date table is all of the dates that I need to calculate how many login/logout events happened broken out by 15 minute intervals throughout each day. These 2 tables are not related, and cannot be related (as far as I can tell). I need to do 3 calculations:
1. Count the number of units that logged in during the 15 minute time interval
2. Count the number of units that were previously logged in and have not yet logged out during the 15 minute time interval
3. Count the number of units that logged out during the 15 minute time interval
I cannot get this to work without running into out of memory errors using the DAX formulas above. Please have a look and let me know if there is a better way to write the formulas or go about calculating this. In my Query1 table I have 2.1 million records, in my Date table I have 4000 records. I can't reduce the number of records as they are all required for statistical purposes. I have tried created a sub table of Query1 with far less columns and am still running into memory errors.
Query1Date