Memory fail

[BishwaR]

I am not able to save the calculation in the model because the memory is not enough. I have 128 GB memory still it is not able to perform the calculation for column which is derived through a measure.

Do I have to upgrade the memory ? Or try to rewrite the DAX. 

I have used Distinct in the Calculate function and I can use Values in place of Distinct. Does it make any difference ?

Or should I restrict the number of rows.

Thanks

[Anonymous]

Hi @BishwaR ,

First, you can find out what consumes memory by looking inside the two links below.

Are Your Power BI Performance Issues Due To High Memory Consumption?

Understanding memory used by Power BI
Then, refer to the following blog to reduce your model size and optimize the DAX:

Optimize/Reduce model:

Data reduction techniques for Import modeling

DirectQuery model guidance in Power BI Desktop

Optimize DAX:

DAX Best Practice Guide

In addition, the following one is the thread with similar problem to yours, check out the solution. Hope he can help you.

Optimize memory

Best Regards

[amitchandak]

@BishwaR , Try rewrite distinct as

Countx(values(Table[Column]), calculate(Max(Table[Column])))

or

countx(summarize(Table[Column]), [Column])

Also, Increase data cache management to 16GB