Calculated Column Memory error

[dosania]

Hi,

I'm trying to create a simple calculated column in my dashboard, but am receiving a memory load error.
I am trying to create a flag which identifies where product costs are greater than budgeted product costs, and see this at both product and store level.

The DAX calcultaed column I have created is;
Cost Flag = if([Incurred Costs] > [Budgeted Costs] ,1,0)

The flag works when I try select just the Product or Store in the table, but not when I try and look at both in the same table as a heirarchy.

I get the following memory load error;

Is there a way I can optimise my DAX calcultion which will allow me to aggregate my calculation to both store and product level and not be too memoy intensive?

Thanks

[v-jingzhang]

Hi @dosania 

Do you have many calculated columns in the table? Calculated columns will be stored in the model and make the table size larger. If possible, you can use measures to calculate the aggregated values. This will reduce the model size. 

For example, I assume that your [Incurred Costs] and [Budgeted Costs] are both calculated columns. You can convert them into measures to calculate the results. Then create another measure [Cost Flag] to compare them. Add these measures to the table visual along with store and product columns. This may be helpful. 

In addition, the following link may be helpful about reducing the data in a visual.

Large datasets, data point limits, and data strategies - Power BI | Microsoft Docs

If you are Power BI admin, you can consider increasing the Query Memory Limit in Power BI Service. 

Chris Webb's BI Blog: The “Visual Has Exceeded The Available Resources” Error In Power BI Chris Webb...

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.