Forum Discussion
Optimizing DAX measures to avoid "Exceeded available Resources" error in Power BI Services
- Hi there
One thing you could do to get an average is take the SUM and DIVIDE it by the Count
My Average = DIVIDE(SUM('Table'[fValues]),COUNTROWS('Table'))
And then use that as a basis for your other calculations.
S_JO21rnr While others may provide a more detailed answer specific to the calculations, here is a couple notes in the limited time I have to respond. First, AVERAGEX is a row by row calculation, this is going to take much longer. Explore just using AVERAGE and filtering the time period to the one you want. Variables will help you do this.
You are creating calculated tables (In Memory) from your base table - this is expensive.
The 1 GB limit only relates to the PBIX file size. Your overall file cannot be larger than that in order to publish to the Service.
The error you are getting is relative to your machine, it is maxing out your local machine memory. 8GB memory is really small if your using large datasets in power bi. The engine uses an all in memory technology that requires more when you scale up in data size.